Hello. I've added basic IOL functionality to an app, but I'm admittedly new to it. 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 tips would be greatly appreciated.

Is there a reason you're trying to use IOL versus standard user fields and form rules? Is there something specific about the User ID you need? You could user a formula-user and User() formula in combination with form rules to store the value to accomplish what it sounds like you're trying to do. Chayce Duncan | Technical Lead(720) 739-1406 | chayceduncan@quandarycg.comQuandary Knowledge Base

I have an app in which I've added @mycompany.com as a user - granting all registered users of my firm basic access to the app, which includes access to a profile table. Users can create a profile for themselves and in so doing identify the role the user should have in the app. Once the form is populated sufficiently, a formula URL field button will appear in the form. The button will use the API_AddUsertoRole call. I need to reference the userID in the API_AddUserToRole call. I don't know how else to get that userID short of IOL, etc.Thoughts?

To expand on my prior comment - the goal is that I don't want myself or my team to be a bottleneck of user management. There may be a lot of users coming/going into the app over time - I want them to be able to dictate their own user experience based on their profile table inputs.

So if I'm understanding: 1) User creates profile, selects role2) User clicks button to add themselves to that particular roleFrom your original description - I'm going to go out on a limb and make an educated guess that you're going to have an issue that unless you granted everyone 'sharing' access to this app or others - they won't be able to add themselves to a new role regardless. Basically their permissions likely won't be high enough to actually apply themselves to a role - because they need 'Basic + Sharing' which opens up the 'Users' tabThat said - another approach might be to re-think how to chain the actions together. Basically - instead of the button adding them in the role - you can use the button to make your API_GetUserinfo call - and then store the user ID in the record as a field - basically the way you want to with IOL - but this way it's user initiated. When that field is written - you could have a webhook fire - and the webhook could do the provisioning of the actual user as a background action that isn't reliant on the particular user trying to provision themselves. Chayce Duncan | Technical Lead (720) 739-1406 | chayceduncan@quandarycg.com Quandary Knowledge Base

Thanks, very much for that. I'm quite happy to do it the way you suggested, but I keep struggling at the point of extracting the userid from the API_GetUserInfo call. I don't know how to parse the userID values from the other values returned in the call. Any tips? Thanks!!

IOL and UserID | Qrew Discussions

11 Replies

ChayceDuncan2
Qrew Cadet
7 years ago
If your question above is related to how to write to a field with the retrieved User ID - You can append another GET request in your formula-url for an EditRecord call. Not sure if thats the desire - the above comments seem to be in a different direction. If thats the need though - you can take the formula I provided above and do something along the lines of:

var text url = "https://yourrealm.quickbase.com/db/main?a=API_GetUserInfo&email=y ouremail";
"javascript: {
$.get('" & $url & "', function(response, success) {
var userId = response.getElementsByTagName('user')[0].getAttribute('id');
$.get('https://yourrealm.quickbasae.com/db/tabledbid?a=API_EditRecord&apptoken=token&_fid_10=' + userId, function(response,success) { window.location.reload() })
})}"

where _fid_10 would be updated specific to the actual field ID you need to store the User ID value in.

Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base

Forum Discussion

IOL and UserID

11 Replies

Related Content

USERID FIELD

IOL Technique

Help accessing the UserID in a Pipeline API_GetUserInfo call

IOL Basics

Client Portal With Userids