This shows you the differences between two versions of the page.

Link to this comparison view

security - by field on record [2016/09/14 14:19] (current)
Line 1: Line 1:
 +====== Security By Field on Record ======
 +Setting up [[Security|security]] according to a [[Field|field]] on the [[Record|record]] to be secured is often done for tables such as purchase orders, invoices, and more. It's also often done in conjunction with other methods of setting up security.
 +===== How To =====
 +  - First, you need to navigate to the [[Page|page]] you wish to secure.
 +  - Next, decide which [[Field|field]] on the [[Table|table]] you wish to use to drive the security. This is often a [[Field Type - Selection|drop-down]] for the status of the [[Record|record]].
 +  - Access the [[Automation Trigger - When Form Loads|security]] for the page/
 +  - Create a [[Action Type - Record Exist|record exist]] [[Action#​Evaluations|evaluation]],​ choose the [[Query Builder - Starting Points#​Current Record|current record]] starting point for the [[Query Builder|query]],​ and create one or more [[Query Builder#​Filters|filters]] to detect the appropriate circumstance(s) you wish to check for (e.g. Status = Open).
 +  - Create the appropriate [[Action|actions]] (either [[Action Type - Hide Form|hide form]] or [[Action Type - Set Modes|set modes]] actions) inside the [[Automation Trigger - When Evaluation Passes|pass]] or [[Automation Trigger - When Evaluation Fails|fail]] section of the [[Action#​Evaluations|evaluation]],​ as appropriate.
security - by field on record.txt ยท Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2020