The “record picker” allows one to search for and select a record by the primary field only, it seems. I would like to see a true search element that can be configured to search multiple fields, or all fields within the specific view.
The primary table contains an appointment date (date field - ‘Appt Date’) and pre-set appointment times (single select field - ‘Appt Time’). We have configured a single-select field (‘Action’) to manually add the record to a view, which successfully ...
Once again, Databaser, thanks for the incredibly helpful instructions!
Because the “Current Time” doesn’t refresh in real time, “Current Time” never equals “Reminder Time” (except maybe occasionally by chance) so the automation never triggers. I chan...
This worked perfectly; thanks!
Regarding the automation, I think it should be configured to trigger “When ‘Reminder Time’ is …X” and ‘Appt Date’ is today. X should probably be current time, but I am not sure what to enter for ‘X’ since ‘Reminder Time...
Thank you, Databaser; this almost worked. Here are the results and a few more details.
Currently, times in the single select “Appt Time” are in the format 9:30am 10:30am, etc. There are entries on the quarter hour: 9:15pm, 10:45am, etc.
The formula (...
