Forum Discussion

GeoffreyHarmuth's avatar
GeoffreyHarmuth
Qrew Captain
8 years ago

populate user ID to a field

I need to be able to extract a user ID from a selected user.


The process is as follows:

When I select a user in a form, I would like to have a formula text field that populates the UserID from that user field.  I have read a similar article:

https://community.quickbase.com/quickbase/topics/extract-user-id-from-a-user-name

But i need a bit of help with the formula that needs to be inputted into the field.  Also, because its an API call, would I have to use a URL formula field and then run the script in that way?

If I can just get all the user information into a field, I can then run the following formula in another field: Left(Right([User Field],"<"),">") to extract the ID only

Please can someone assist with the format of the API call formula: API_GetUserInfo


Thanks
App builders
  • MalcolmMcDonald's avatar
    MalcolmMcDonald
    Qrew Cadet
    3 years ago
    I hope you got a satisfactory result all those years ago -- for future searchers (like me!) I found the quickbase fuction "UserToID" which returns the quickbase user ID.

    In my use case, i'm creating a QR code for a badge - the QR code has the userID embedded - that calls to a 3rd party website that pulls specific data via the API from quickbase about the user. So it'd be something like www.badgegizmo.com?userid=1231231.zzzz that would show a page of cool stuff about that user.






    ------------------------------
    Malcolm McDonald
    ------------------------------
  • ChuckGrigsby's avatar
    ChuckGrigsby
    Qrew Cadet
    8 years ago
    I read the post and do not like the native way. I would suggest the api call. You'll need the users email so could just have a field on the form. You'll need to implement the IOL technique if you have already. Feel free to contact me if you need coding help. Chuck@chuck.support
    • _anomDiebolt_'s avatar
      _anomDiebolt_
      Qrew Elite
      8 years ago
      > ... do not like the native way. ... You'll need to implement the IOL technique




      Goofus employs the IOL, BOL and SW techniques with QuickBase to achieve the impossible.




      Gallant uses only native QuickBase features and waits for proper releases.
      • JimHarrison's avatar
        JimHarrison
        Qrew Champion
        4 years ago
        Trying to be Gallant, forced into Goofus because priorities. Lol

        ------------------------------
        Jim Harrison
        transparency = knowledge + understanding : The Scrum Dudes
        ------------------------------
    • PatrickDunn's avatar
      PatrickDunn
      Qrew Assistant Captain
      6 years ago
      Hi Chuck. I've implemented the IOL technique, but I'm struggling to do the rest. In a form, when a user dropdown changes, I want to run  API_GetUserInfo for the user chosen in the dropdown and then populate a field of the form with the user's userID. Any suggestions would be greatly appreciated.