Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 11/03/2020 in Posts

  1. Bloom

    Disable Autocomplete

    /* Turn autocomplete off on form*/ document.getElementById("caspioform").setAttribute("autocomplete", "off"); /* Turn autocomplete off on each input text element*/ if (document.getElementsByTagName("input").length > 0) { var inputElements = document.getElementsByTagName("input"); for (i=0; i < inputElements.length ; i++) { if (inputElements[i].getAttribute("type") == "text") { var att = document.createAttribute("autocomplete"); att.value = "off"; inputElements[i].setAttributeNode(att); } } }
    1 point
  2. Hello @sandy159, You may try to add this code to the DataPage Footer section: <script type="text/javascript"> document.addEventListener('DataPageReady', updateColor); function updateColor() { const recordsListArr = document.querySelectorAll('[id*=InsertRecord]'); recordsListArr.forEach(element=>element.addEventListener('change', (event) => { element.style.backgroundColor = '#acdbdf'; }) )}; </script> By this code we select all source fields that have the following Form elements: Text Field/Text Area/Dropdown/Listbox. You may customize the ba
    1 point
  3. Hi, just to add to the previous comment above. If you have created a Trial account it will be automatically be deleted after 14 days. All the resources and objects in your Caspio Bridge account will also be deleted.
    1 point
  4. Hi Team, It is possible format the output result page fields to have a grid just like a table in Excel? Thank you in advance
    1 point
  5. I found my error: I inserted the id (id="btnAdd") to the input section instead off as part of the div parameters. <div id="btnAdd" style="display:none; justify-content:flex-end; width:50%; padding:0;"> <input class="cbSubmitButton" type="button" ..... (Before I found this error, I also set the page to be responsive.) Thanks so much for you great solution, Sandy159 Floris
    1 point
  6. You can also make use of Pivots on these: https://howto.caspio.com/datapages/reports/pivot-table/
    1 point
  7. Yes, thank you so much @sandy159 -- that worked. I really, really appreciate you taking the time to help me with this. Have a nice day
    1 point
  8. Hello @SaraK, Thank you for the detailed explanation. You have made a big research on this as well and were so close. Please try to use the following formula in the Calculated field to get the number of IDs that were Submitted Today: SELECT COUNT([@field:Request_ID]) FROM curbsideEntries WHERE DateDiff(day, [@field:Timestamp], SysDateTime())=0 Hope this helps! Please let me know if it works for your case. Regards
    1 point
  9. Hello, just to add in the previous comment above. As I understand, you want to create a search field which can search to the different fields, right? If that is the case, on your table, add another field and set it to Formula. Then, concatenate the fields you want to use in your report. If all your field are in Text datatype , you can use [@field:FieldName1] + ' ' + [@field:FieldName2] + ' ' + [@field:FieldName2] on your Formula Field. Then, use this formula field as your search criteria, it should look like the attached screenshot. I hope that helps.
    1 point
  10. Hello @roeithemeiriman, If you created a Trial account, as I remember it will be deleted automatically in 14 days. No action is required from your part. In case you created a Free account, you can easily delete it. Please go to the top menu Account -> Usage and Billing -> Cancel Account. Here are screenshots for better visualization. Screenshot_1 Screenshot_2
    1 point
  11. Hi @SunakoChan, Yes it is possible to format the out put of the gridline of the result page in tabular report using Style. Go to Style > Edit > Result Page > Table Layout > Data Cells > Border color: Change the black(or color that your prefer) and size 1px. Here is the expected result:
    1 point
  12. SinJunYoung

    Edit used Formula

    Since altering the formula may be an issue, I would like to suggest creating another formula field and copying the formula from the previous one so it gets you a fresh set of field. I am thinking that the system automatically preserves the alteration of the field to avoid failing and possible incompatibility issues.
    1 point
  13. Hello @richs, I believe you may have this problem because [@field:town] is the text value. You may get the value of the Mill_rate from your lookup table with the following formula so it will be the Number type: SELECT [@field:Mill_rate] FROM Town_lookup WHERE Town=target.[@field:Town] And then you can have another calculated value which is [@field:House_value]*[@field:Mill_rate]/1000 Just change the names of the fields to yours. Hope this helps!
    1 point
  14. Caspio Bridge 21.0 release brought a Tasks\Trigger enhancement which solve this case without complex Trigger\Tasks. There is a new block added to Triggered Action called "Table variable" which forms a table. You can insert table variable into email body and it will be formed link a table (HTML format enabled): Hope it helps someone.
    1 point
  15. I have not tried the code but syntax needs a little modification: <script src="https://code.jquery.com/jquery-3.2.1.min.js"></script> <script> $(document).ready(function(){ $("table[data-cb-name='cbTable']").removeAttr("title"); }); </script>
    1 point
  16. Thank you @tellyfor sharing! Also, just wanted to add that we can do tons of customization to our Caspio DataPages whether you are familiar with basic CSS or not because they already have some elements we can edit on the Styles. I can recommend going through the articles related to Styles, this video might come in handy too, and of course, going through each element when you have time, will be very helpful in the future if you want to edit other element's styles.
    0 points
×
×
  • Create New...