Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
I have an app which it contains pay rates and I'm always nervous about those kind of apps. Quick Base is secure, but what if a manager leaves their userid signed on in a meeting room, for example, even if they were using a different App. So much for security.
So in our case we had each user need to enter a secret code to a table on the dashboard of the app and that gave access for 30 minutes.
So you could do the same thing.
Set up a single record with Record ID# = 1 and then have a field that needs to be entered with the secret code. Then calculate if the code is correct and the Date Last Modified is within the last X minutes as a formula checkbox called [Allowed to View]. Lookup that checkbox field to the detail records on the dashboard via a reference field like
[Link to control record (=1)] which is a formula numeric formula of 1.
Then set permissions that certain Roles may only see detail, records where that [Allowed to view] is checked.
So basically you enter the secret code and get say 10 minutes of use.
My setup was a bit different so you would probably have to have a form rule "when the record is saved" to update a date/time stamp field to the current date time when the record is saved (to ensure that the record was updated) and to copy across the secret code field to another field hidden field and blank out the data entry secret code field.
So in our case we had each user need to enter a secret code to a table on the dashboard of the app and that gave access for 30 minutes.
So you could do the same thing.
Set up a single record with Record ID# = 1 and then have a field that needs to be entered with the secret code. Then calculate if the code is correct and the Date Last Modified is within the last X minutes as a formula checkbox called [Allowed to View]. Lookup that checkbox field to the detail records on the dashboard via a reference field like
[Link to control record (=1)] which is a formula numeric formula of 1.
Then set permissions that certain Roles may only see detail, records where that [Allowed to view] is checked.
So basically you enter the secret code and get say 10 minutes of use.
My setup was a bit different so you would probably have to have a form rule "when the record is saved" to update a date/time stamp field to the current date time when the record is saved (to ensure that the record was updated) and to copy across the secret code field to another field hidden field and blank out the data entry secret code field.