Forum Discussion

Qrew Commander

3 years ago

Need a sneaky workaround for a dynamic form rule issue.

Current Setup as follows: Employees have Many Audits. Employee Table with fields: Name (text field), and User Name (User field). Audit table with lookup fields: Employee Name (Text, Proxy) G...

Form Rules

Forms

MarkShnier__You

Qrew Legend

3 years ago

You say: I have a formula query on my Audit table that goes and finds the record ID in the Employee table, of the Current user

Can you change the query to only return a record ID if the employee is an Auditor?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

MikeTamoush
Qrew Commander
3 years ago
Ahhh yes I am sure there is a way! That should do it thanks as always!

------------------------------
Mike Tamoush
------------------------------