If I go into Options, and Trigger After Open, and then paste in:
Thereafter, when I open the database, it goes directly to the Cards view of my Contacts table and slides open the Contact detail form, which is really nice.
There is only one problem. I appear to be forever locked out of the view that shows the Data Model and Options tab. Is there a way to get back to that view? If I close and re-open the database it now always skips that view, per my Trigger After Open code.
I have reverted to a backup, but I am still curious if there is a key combination or some other way to skip the Trigger After Open action.
I figured out a way to avoid the lockout and still allow users to open a database directly to the table of their choice, try this example:
1. create a database with Contacts, Transactions and Preferences tables.
2. add a Choice field to the Preferences table with items:
3. add the following under Options tab "Trigger after open":
let v := text(record(Preferences,1).Choice);
if v = "Contacts" then
if v = "Transactions" then
To regain access to the Data Model and Options tab, set the Preferences Choices field to "empty" before closing database.