douvega

If you want to copy data from one account to another, then you can try using the Caspio API. However, you must be aware that this could be a costly operation depending on how many records you are copying. If you share why you are trying to do somethink like that, maybe we can find a work around. Regards.

Thanks, the following code should work: <a href="#" id="myLink_[@field:Nurse_ID]" target="_blank"></a> <script> if([@calcfield:1#] > 0){ document.getElementById("myLink_[@field:Nurse_ID]").innerHTML = "Edit Password"; document.getElementById("myLink_[@field:Nurse_ID]").href = "https://MyAcct.caspio.com/dp/1234?Nurse_ID=[@field:Nurse_ID]"; }else{ document.getElementById("myLink_[@field:Nurse_ID]").innerHTML = "Add Password"; document.getElementById("myLink_[@field:Nurse_ID]").href = "https://MyAcct.caspio.com/dp/1234?Nurse_ID=[@field:Nurse_ID]"; } </script> I was not able to test this code but please let me know if it works as expected.

Hi @BFuchs Your code is not working for all rows since you are generating several items with the same id "myLink", remember each id must be unique. Could you please identify a field within the table which is unique so I can provide you with the proper JS? Tell me the full name of the unique field.

Hi @Ras2019 What is the datatype for [@authfield:Company_Users_tbl_Company_ID] field? Is it autonumber, random ID, GUID??

Hi @gsgriffin Your question seems to be a bit confusing. Do you have a sample page we can look at to see what the issue is? Regards

It seems to me that you need a one to many relationship since one bid can contain many materials. https://howto.caspio.com/tables-and-views/relationships/

I posted a NodeJS sample code to get the authorization token in the following post: You can reuse the code for making more calls as needed.

In case someone is looking to connect to the CASPIO API using NodeJS, here is the code sample to get the authentication token. const https = require('https'); const querystring = require('querystring'); const data = querystring.stringify({ "grant_type": "client_credentials", "client_id": "[INSERT CLIENT ID HERE]", "client_secret": "[INSERT CLIENT SECRET HERE]" }); const options = { protocol: 'https:', host: '[INSERT CASPIO ACCOUNT HERE].caspio.com', path: '/oauth/token', method: 'POST', headers: { 'Content-Type': 'application/json' } }; const req = https.request(options, (res) => { console.log(`statusCode: ${res.statusCode}`); res.on('data', (d) => { process.stdout.write(d); }); }); req.on('error', (error) => { console.error(error); }); req.write(data); req.end();

Replace your code with this: <script type="text/javascript"> function f_listbox(fieldObj) { //Set field to multi-select fieldObj.multiple = true; //Get field values var values = fieldObj.value; if (values.indexOf(",") > 0) { for (var i=0 ; i < fieldObj.options.length; i++) { if(fieldObj[i].value == values) { fieldObj.remove(i); break ; } } var arr = values.split(", "); for (var j=0 ; j < arr.length; j++) { for (var i=0 ; i < fieldObj.options.length; i++ ) { if(arr[j]== fieldObj.options[i].value){ fieldObj.options[i].selected = true; break ; } } } } } setTimeout(f_listbox(document.getElementById("YOUR:FIELD:ID")), 20); </script>

Hi @davidhshugar I know you have sorted this partially, however, I would bring another solution for you. You can use REST API to post (create) the record everytime a user opens the webpage. I recommend you using this service which lets you do these type of integrations very quick. No datapage autosubmit needed but it is either JS or jQuery dependant to accomplish your goal. I hope you can explore this option, if you need help send your questions.

Maybe you are missing a variable in your JS since that post is made to have your options selected. Please send the JS you are using to check it.

It would be better to hide buttons from the Style directly. Create a new Style and apply it to the datapage you would hide the buttons from. Go to Source tab inside the new style and then select "All" from the left tree options under Datapage Elements section. Look for the type of container you are trying to hide, selections might be: cbSubmitButtonContainer, cbBackButtonContainer, cbDeleteButtonContainer, cbSearchButtonContainer, cbLoginButtonContainer, cbUpdateButtonContainer, cbPasswordRecoveryButtonContainer, cbPasswordResetButtonContainer Find what you are looking for and add the following line inside the class attributes: display: none; That way you will be hidding the buttons you want from the datapages you want without using JS. I hope it helps

Hi @ronbrumbarger, You can not access data from another table within a table. You can surely access cross table data from Calculated fields in your datapages. What is the purpose of having something like that in your app? Generally, there are workarounds that might work for you but you must be more specific about why you are trying to do that. Looking forward to hearing from you...

Hi @wimtracking2, Reason is because you can not call List - String fields with the API. You must change how you multiselect stuff. My advise would be to explore 2 options: Change from List - String to Text64000 and use a JS or jQuery plugin in your datapage such as https://select2.org/getting-started/basic-usage Follow this Caspio solution for a Multiselect Listbox option: https://forums.caspio.com/topic/4315-js-multiselect-listbox-in-update-datapage/ This would store selections as comma separated values and Zapier will be capable of reading the field values. I hope it helps.

Select the field in the datapage and go to the Advanced tab Under "External Associations and Defaults" section, enable the On load option and select "External Parameters" from the dropdown. Remove what is in the parameter text field and paste the today date parameter [@cbTimestamp*]