Using a Popover for data entry and to Navigate Portal Rows
This all started as I was building a Bill of Lading for an art storage company.
In developing this solution I ran into an issue where I couldn't easily fit all the fields needed for data entry in the portal row.
There was also the need for data entry to be fast and they wanted to be able to stay on the keyboard.
Setting up the popover
- The first item on the agenda was how to display the portal row in the popover that’s outside the portal. This was easy as I already had a relationship…
- This is my standard method for creating related records.
Launching the Popover
- Next I needed a list of Record IDs from the portal to step through. The button to trigger the edit is in the portal row so the script was pretty easy…
- Capture Portal Row
- Setup a List of IDs
- Get the value of the portal row clicked.
Code() & Get (TriggerKeystroke)
- Code - Returns the Unicode code points for the characters in text
- up arrow = 29
- down arrow = 31
- Get ( TriggerKeystroke )
- Returns the characters that activated an OnObjectKeystroke or OnLayoutKeystroke script
- So we wrap it as so Code ( Get ( TriggerKeystroke ) ) = XX
Stepping up (or down as the case may be)
- Next I needed a list of Record IDs from the portal to step through. The button to trigger the edit is in the portal row so the script was pretty easy…
- with Capturing the Keystoke added...
- Setup a List of IDs
- Get the value of the portal row clicked.
Closing the Popover
- When the popover closes we need to clean up…
- Clear Variables and the CR_Nav global
Entering a New Item
- After creating a new record we need to access the popover...
Documentation