SouheilKaram
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Import from Excel into a form
Hi, One approach I have done for a customer is to allow them to attach the CSV file to the form and add a button to the form. When user clicks the button I execute a quickbase page that loads the attached excel data to the form based on the form record_id or key. The caveat is that the name of the header fields in the excel file must match the field names in the table where the form is attached to in quickbase. This way the data in the excel will map to the record and attributes in quickbase. I can provide you with the javascript code-page for your use. Let me know if I can help you by talking about workflow specifics. Reach out to me at sckaram@gmail.com. Below is a screen shot example. Rather than CSV you will attach excel. ------------------------------ Souheil Karam ------------------------------Re: Using a barcode scanner to associate multiple existing child records to a parent record.
Hi Ben, Take a look at this mobile application I setup. It solves exactly what you are looking for. I used my kitchen cabinet as a pallet and the stuff in it as my parts on the pallet. to use: 1 - install the pic2shop pro from apple store or google play. you will need to spend about 26 $$ one time purchase. It is worth it because you can use the app with many users you want 2 - use you camera to scan the barcode below 3 - enjoy, and reach out if need to customize accordingly. ------------------------------ sckaram sckaram ------------------------------Re: Limit on Payload Size for ImportFromCSV Call
Hi, I have not tested the limit. But I do load very large csv files in chunks using the api. I have a million records in another database system and I usually extract them into chunks of 100,000 records to a csv and load them with the ImportFromCSV api call. Ten loads. I went as large as 300K load per chunk and it worked. ------------------------------ sckaram sckaram ------------------------------Re: Do you want to start a local QB builder community?
HI Jacob, Myh name is Souheil Karam. I have been using QuickBase for at least 8 years. I am interested in starting a builder community in my area, Seattle, Washington. Please feel free to rach out to me at souheilkaram@chameleonplm.com. ------------------------------ sckaram sckaram ------------------------------Re: Send a POST request with a button or webhook?
Hi Geoffrey, You can do this easily with QB webhook capability. The only catch is that your http request becomes an https request. Since you already have a button that allows you to update or edit the record, then with a webhook function you can send the above url to your php proxy and include any fields, i.e Device_ID. If you do not have an https server then you might want to execute the url in a popup window to the back-end.Re: How do you use API to add a user and then send an invitation?
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();
