Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
4 months ago
Solved

Get the role of a user in a user field

I know for years getting this information has been almost impossible.  I wanted to see if there has been any updates. I need to be able to pull back the user role of a user listed in a user field. ...
  • ChayceDuncan's avatar
    ChayceDuncan
    4 months ago

    So I went and tried it myself - I got the same error you got but it allowed me to run and it operated/saved as intended. I'm not sure why it thinks there's an error - but try and turn it on and see if you're able to get it to work. 



    ------------------------------
    Chayce Duncan
    ------------------------------
CarolMcconnell's avatar
CarolMcconnell
Qrew Captain

Okay, so this worked great and it did bring back the user role.  Thank you so much for that.

So now I have  an update record step and have selected the updated record and the field that I want to update which is assigned to.  What do I put into the assigned to field to get it to update?



------------------------------
Carol Mcconnell
------------------------------
ChayceDuncan's avatar
ChayceDuncan
Qrew Captain
4 months ago

I'm not sure I understand. Are you asking how you grab the role value to log back into Quickbase?

If that's correct - then you need to target the right part of the JSON response and put that into your update record. So lets say your trigger is on the new record - then you look up the user and then you want to update the value of 'Assigned To Role' in the original record then you would just do a regular update record action, and in the input for Assigned To Role you would do something like; 

{{b.json.qdbapi.user.roles.role.name}}

Where b is the request step to get the role. The json.qdbapi.... is the key path structure to get the name of the role. 



------------------------------
Chayce Duncan
------------------------------
  • CarolMcconnell's avatar
    CarolMcconnell
    Qrew Captain
    4 months ago

    Yes, that is exactly what I'm wanting to do.  I'm getting an error, this field contains invalid jinga references.  {{b.json.qdbapi.user.roles.role.name}}



    ------------------------------
    Carol Mcconnell
    ------------------------------
    • ChayceDuncan's avatar
      ChayceDuncan
      Qrew Captain
      4 months ago

      Can you screenshot or download the yaml to post here to look at? The jinja I provided is based on the key path for a single role in my example and works for me - you should be able to confirm by looking at the activity log and specifically under the request to get the role you should get something like this in the log: 



      ------------------------------
      Chayce Duncan
      ------------------------------
      • CarolMcconnell's avatar
        CarolMcconnell
        Qrew Captain
        4 months ago

        I'm attaching.  It does bring back the user id and name, I just remove them due to privacy.



        ------------------------------
        Carol Mcconnell
        ------------------------------