Forum Discussion

NathanWells's avatar
NathanWells
Qrew Member
6 years ago

Dynamic Form Rules & Permissions

Looking for a little help.  I have a Meeting Notes QB.  I have a Multi-select text field for Attendees and a checkbox field for "Make Private".  The idea is that if the checkbox is checked, I want to restrict viewership to only those contained within the Attendees field.  Is this possible or do I have to use a "User" field instead?

Thank you,

------------------------------
Nathan Wells
------------------------------
Forms
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    You will need to use a list user field type. 

    Then make a formula field called [not Private or User is Attendee?] with the formula

    not [Make Private]
    or
    Includes( [Attendee List User field], User())


    Then set the custom permission fir that Role where that checkbox field is checked. 


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------