Forum Discussion

MikeTamoush's avatar
MikeTamoush
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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew 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's avatar
    MikeTamoush
    Qrew Commander
    3 years ago
    Ahhh yes I am sure there is a way! That should do it thanks as always!

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