Hello,
I am working on a register where users mainly interact with a Card widget with dependent dropdowns and role-based visibility (RegOld and RegNew tables).
My challenge:
-
By default, the Card always opens on the first record (Row ID = 1).
-
I would like it to open directly on the last record (highest Row ID or latest Prob_ID) while still keeping the navigation arrows (← →) active.
What I already tried
-
Sorting the table / form by Row ID or Prob_ID (descending) → No effect, the Card still opens on record 1.
-
Using Action Button columns directly in RegOld and RegNew, with two helper columns (IsNew and Action_Next).
-
IsNew to flag the newly created row,
-
Action_Next to jump focus to it.
The buttons worked for ‘Add record’, but the result was the same: -
On reload, the Card still defaults to record 1
-
If I force focus via these columns, I again lose navigation arrows.
So this approach also didn’t solve the requirement (open on last record + keep arrows).
-
-
Using the Widget Builder to create a custom ‘Add record/Next’ button, and navigate records programmatically. The button worked in terms of triggering, but the behavior was inconsistent: either it still reset to record 1 on reload, or the navigation arrows stopped working (same issue as with ‘Select by’). So, even with a custom widget, I couldn’t achieve ‘open on last record by default and keep arrows’.
-
Using a Nav table with formulas such as: RegOld.lookupOne(Row ID == max(RegOld.Row ID))
and linking the Card with: Select by → Nav.LastRegOld
OK - This works (Card shows the last record)
NOK - But then the navigation arrows disappear, since the Card only sees one record -
Form + Table combination:
-
A table sorted DESC + Card “Select by Table”.
-
Works for manual selection, but still defaults to record 1 at startup unless you click.
-
-
Session test: Grist sometimes seems to remember the last selection, but after clearing cookies/cache, it always resets to record 1.
Related threads I checked
I already looked at similar discussions:
These are close, but they don’t fully solve my case.
==> What I am looking for is: a Card that opens by default on the last record while still allowing navigation with arrows.
Thanks in advance! 
NB : One additional complexity in our setup: the register is bilingual (FR/NL) with dependent dropdowns.
I almost solved this part, but still couldn’t manage to lock each row in the language it was originally encoded in.
This makes the ‘open on last record + keep arrows’ request even more important for me, because the Card is the only user-friendly entry point in such a setup.