douvega

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*]

You must create a field that captures the csv field in your app. Parse the file with Integromat POST the rows to Caspio using Integromat Those are like general steps but you will need writting JS and using APIs for achieving it. If you do not have time to do it, the best way to proceed will be to hire a developer since that is not an easy task.

Did you actually checked the tool? I was able once to import csv files with that service for a customer, it is not wasy but it is possible

Check this post: https://forums.caspio.com/topic/7636-api-to-import-data-from-end-user/?do=findComment&comment=23627

Hi, Even when the caspio storage space you receive is enough, I would say it will limit your app in the future in case you continue to upload new PDF files. Remember Caspio is a database service, if you would like to sync with storage service providers, I would recommend using a storage service provider such as AWS S3, Dropbox, Google Drive. You can integrate any of these service with Caspio by using the API methods out there. If you are not sure about how to proceed, I would recommend you taking a look to this service so you can build your own API integrations easily. Hope it helps. Regards.

Hi, If someone else face this limitation, I can recommend using API coding to get any amount of records you need created in your tables. In case you are not an API savvy, you can still create your own logic by using Integromat (a service that lets you connect with dozens of apps without having to write code), you could even set up .csv uploads directly into Caspio tables. Hope it helps. Regards.