Forum Discussion

HannahEngelson's avatar
HannahEngelson
Qrew Trainee
14 days ago

Field to "assign" a user group

I have an app tracking our department's flight delays. Depending on origin/destination of the flight, it's assigned to a group at a specific base. I currently have my app set up to "assign" the delay to a specific user with a table to table relationship based on airport code. On the dashboard, reports pull data based on the current user being in the "assigned" field. More than one person in each base may be responsible for following up with these delays. 

Is there a way to designate a user group, or multiple users (without making separate fields for each position) instead of one user to a record?

If I can offer any other information to advise on this, let me know! Thank you!

  • Let's start with the basics.  There is a field type called List-User that is a data entry field type where you select multiple users in the same field.

    There you can make reports which are filtered  where that List-User field includes <the current user>.

    Look for that built in choice for the filter.

     

  • Let's start with the basics.  There is a field type called List-User that is a data entry field type where you select multiple users in the same field.

    There you can make reports which are filtered  where that List-User field includes <the current user>.

    Look for that built in choice for the filter.

     

    • HannahEngelson's avatar
      HannahEngelson
      Qrew Trainee

      Fantastic. So then can I have a table relationship where I have one record for each user assigned to that base. Then connect it based on the airport code to pull each of the users?

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        Well, I'm assuming that on the airport code table you will have a List-User field, which will give all the users who are responsible for that airport code. Then you can look up that List-User field down to the delays.   That will allow you to pull reports where the current user is listed on the airport code for that delay.

  • This is exactly what I have created! I don't have much experience with the List-User field and now I know how helpful it can be! Thank you as always!