Skip to main content
Question

populate user ID to a field

  • September 2, 2017
  • 0 replies
  • 258 views
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

    • ChuckGrigsby
    • Registered
    • September 3, 2017
    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
    Forum|alt.badge.img+6
    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
    ------------------------------
      Terms & ConditionsAccessibility statement