Forum Discussion

JonJon's avatar
JonJon
Qrew Trainee
13 years ago

How do you use API to add a user and then send an invitation?

I have created a form that contains 3 fields, First Name, Last Name, and email. I would like to be able to create a button with a formula URL field that takes that information and does 3 things: 1...
APIs and custom code
Forms
NotificationsEmail
SouheilKaram's avatar
SouheilKaram
Qrew Trainee
13 years ago
OK Jon. Her is one solution.

1 - Create a formula url that has the domain,app_dbid,roleid,email,fname and last name as below. Also load the QuickBaseClient,js:

"javascript:" &"var QBU_domain='https://xxx.quickbase.com'" & ";" &"var QBU_dbid='bedmkj7zj'" & ";" &"var QBU_roleid='11'" & ";" &"var QBU_email='souheil.karam@gmail.com'" & ";" &"var QBU_fname='souheil'" & ";" &"var QBU_lname='karam'" & ";" &"var scriptElem = document.createElement('script');" &" scriptElem.setAttribute('language', 'JavaScript');" &" scriptElem.setAttribute('src', '/js/QuickBaseClient.js'); " &" document.body.appendChild(scriptElem);" &" function loadScript(scriptURL) {" &" var scriptElem = document.createElement('script');" &" scriptElem.setAttribute('language', 'JavaScript');" &" scriptElem.setAttribute('src', scriptURL); " &" document.body.appendChild(scriptElem);" &"}" &" loadScript('/db/" & Dbid() & "?act=dbpage&pagename=SendInvitationToUser.js');"

2 - Create a user file in your quickbase call it SendInvitationToUser.js with the code below:
function SendInvitationToUser() { var rc; var qdb = new QuickBaseClient(QBU_domain); rc = qdb.errorcode; // if success, begin process if ( rc == 0 ) { // provision the user var userid = qdb.ProvisionUser (QBU_dbid,QBU_roleid,QBU_email,QBU_fname,QBU_lname); rc = qdb.errorcode; if ( rc ==0) { // we have a userid let us invite him with the roleid var Invitation = qdb.SendInvitation(QBU_dbid,userid); } } if ( rc == 0 ) alert("success"); else alert("failure"); } // call on load
SendInvitationToUser();