0

Locked out

If I go into Options, and Trigger After Open, and then paste in:

 

openTable("Contacts", "Cards");
popupRecord(record(Contacts,1));

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.

1 reply

null
    • Choices_Software_Dean
    • 5 yrs ago
    • Reported - view

    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:
    empty
    Contacts
    Transactions

     

    3. add the following under Options tab "Trigger after open":

    let v := text(record(Preferences,1).Choice);
    if v = "Contacts" then
    openTable("Contacts", "(all)");
    popupRecord(record(Contacts,1))
    else
    if v = "Transactions" then
    openTable("Transactions", "(all)");
    popupRecord(record(Transactions,1))
    end
    end

    To regain access to the Data Model and Options tab, set the Preferences Choices field to "empty" before closing database.

Login to reply

Content aside

Categories

View all topics
  • 5 yrs agoLast active
  • 1Replies
  • 1004Views