Jmichael1425

hi @Jmichael1425,
 
you'd simply have to duplicate these two lines:
var field = document.querySelector("#InsertRecordColor");
        field.type = "color";
 
and specify the field names you need. in your case, since it's going to be four, it would look something like:
 
<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {
 var field1 = document.querySelector("#InsertRecordColor1");
 var field2 = document.querySelector("#InsertRecordColor2");
 var field3 = document.querySelector("#InsertRecordColor3");
 var field4 = document.querySelector("#InsertRecordColor4");
        field1.type = "color";
        field2.type = "color";
        field3.type = "color";
        field4.type = "color";
});
</script>
 
The only thing you need to replace are the ColorX in each document.querySelector("#InsertRecordColorX") to your actual field names.

I just found a third party tool that allows you embed a snippet of html on to your website using a button. So when you click the button it offers the end user a way to upload a csv file. Its called EasyCSV.io
Its a direct integration into Caspio and its only $39 USD a month. The only downside is you will have to get their support involved and they are a little slow to respond. However, extremely friendly and wanted to help. They made screen share videos and explained the issue and how to fix the issue or showing what work they did for me. 
The reason you have to get them involved is because if you set it up on your end, the refresh token expires every 24 hours, meaning you have to reset it up in 24 hours. However they can set it up where it auto refreshes the token every 12 hours so you never have to worry about it expiring. Also, its cheaper than paying integromat or zapier to do this.

I just found a third party tool that allows you embed a snippet of html on to your website using a button. So when you click the button it offers the end user a way to upload a csv file. Its called EasyCSV.io
Its a direct integration into Caspio and its only $39 USD a month. The only downside is you will have to get their support involved and they are a little slow to respond. However, extremely friendly and wanted to help. They made screen share videos and explained the issue and how to fix the issue or showing what work they did for me. 
The reason you have to get them involved is because if you set it up on your end, the refresh token expires every 24 hours, meaning you have to reset it up in 24 hours. However they can set it up where it auto refreshes the token every 12 hours so you never have to worry about it expiring. Also, its cheaper than paying integromat or zapier to do this.