douvega

What you are looking for is possible with the AWS S3 API, there is a method to create a signed URL to your file and you can set the live time to 1minute for example so links are valid only for that time frame, anyone using the link out of that frame will get an error message from aws. It is not necessary to set your bucket public and the user get a more natural experience since it is secure without having to put in a password everytime he wants to view a file. Process starts from putting the initial file since it has to somehow relate to your Caspio record, it could be a complex process but it is a completely doable integration. This is not, unfortunately, a do yourself task if you do not have the technical knowledge about APIs. I recommend you to hire a developer for that, or if you want to give it a try, AWS has good documentation on using their API. I hope this can help you solving your issue.

I think this Caspio tutorial is what you are looking for. I hope it can be of help. Regards.

Hi, Yes, passing the WordPress logged in user email as a parameter is completely possible. However, you must be a bit techie to get it done, you could create a button using the WP method wp_get_current_user() in the PHP of your site and then pass the email as URL parameter. I found this article on the web which could help you If you do not have the expertise of doing something like this, I would encourage to hire someone to do it for you as you may cause serious damage to your site if it is not done properly. I hope this gives you some light on what you are trying to do. Best Regards.

Hi there, Based on my experience, these type of services such as Squarespace or Weekly suffer some limitations when combining it with such a powerful service like Caspio. I would rather advise to create your own HTML site for hosting your web application, you will discover it is easy and the interface and other functionalities have no limits, you on control over everything. Another good alternative, in case you do not want to play with HTML coding is a WordPress site, you can manage your pages in the way you need with a drag and drop site builder. It all depends on your needs. I invite you to see this app I created with Caspio so you really see Caspio potential when using custom HTML interface: CASPIO WEB APP EMBEDDED IN HTML SITE

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.