Jump to content

Meekeee

Caspio Moderator
  • Content Count

    222
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by Meekeee

  1. Hi @Mikey, I think what you can do is have a lookup table for your default image and get the FileStor link to your Submission Form as Calculated Value for the image link to be saved in your table. You might refer to this post and article about FileStor CDN: https://howto.caspio.com/files-and-images/filestor-cdn/ By means of Calculated Value, you can get the value in your field by using SQL: https://howto.caspio.com/function-reference/ Calculated Value: https://howto.caspio.com/datapages/datapage-components/calculated-values/ I hope it helps!
  2. Have you tried to check this article for previewing images: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/create-a-lightbox-view-for-images/
  3. Hi @GWBjr, You could check these articles about Grid Edit and Report DataPages: https://howto.caspio.com/datapages/reports/data-editing-options-in-reports/ https://howto.caspio.com/datapages/reports/ https://howto.caspio.com/datapages/reports/creating-a-report-datapage/ I hope it helps!
  4. Just an update: Caspio released a new awesome video about Progress Bar. You might check this one out!
  5. If you want to retrieve your images like the value in your Calculated field, you could enable FileStor CDN on your images and get the File URL of it and save to your table. Or also save a code of HTML along with the URL and rendered as HTML. For more information about FileStor, check it here: https://howto.caspio.com/files-and-images/filestor-cdn/
  6. You could do this by using Virtual and set it as Calculated Value. On your Calculated Value, you could have a CASE WHEN statement that will check if the field is blank or not then use this Virtual field in your Notification email. For reference: https://howto.caspio.com/datapages/datapage-components/virtual-fields/ https://howto.caspio.com/datapages/datapage-components/calculated-values/ https://howto.caspio.com/function-reference/ I hope it helps!
  7. Hi @JanineB, You can check this link that I have found to get the Yesterday's date: https://stackoverflow.com/questions/16686640/function-to-get-yesterdays-date-in-javascript-in-format-dd-mm-yyyy I hope it helps!
  8. Just an update: You could use the Calculated Values on this one. Calculated Value form element generates dynamic calculations that automatically update as users interact with your form. Similar to Formula Fields and Calculated Fields, you can construct the calculation using functions, logic, constants, values from other fields and SQL expressions that you can use for your Total: https://howto.caspio.com/datapages/datapage-components/calculated-values/ Hope it helps!
  9. Hi @merilthornton, You may check this article for Formatting your field: https://howto.caspio.com/datapages/datapage-components/field-formatting-options/
  10. Hi @Youssik, Just an update. You may also use the new feature TASK on this certain scenario. This allows you to update data and send emails based on a predefined time schedule which you can use to your workflow. To know more about Tasks, check it here: https://howto.caspio.com/tasks/ Check this video for more information I hope it helps!
  11. Just an update, you can also check this post for TO field for email addresses: I hope it helps!
  12. Meekeee

    Email

    Hi @JanineB, You could try using Virtual Field and set it as Calculated Value. Calculated Value form element generates dynamic calculations that automatically update as users interact with your form. Similar to Formula Fields and Calculated Fields, you can construct the calculation using functions, logic, constants, values from other fields and SQL expressions that you can use in Virtual Field then put it in HTML Block. After that, you can hide the Virtual field itself. For more information about Calculated Values, check this article: https://howto.caspio.com/datapages/datapage-component
  13. Just an update: Caspio released a new awesome video about Progress Bar. You might check this one out! I hope this helps!
  14. Just an update: Caspio released a new awesome video about Progress Bar. You might check this one out! Hope it helps!
  15. You can use App parameter. You can set this as a 'Long Text' type that stores up to 64000 characters then call it in your HTML Block. Check this article for more information: https://howto.caspio.com/apps/app-parameters/
  16. You can change it by this code: <style> td[data-cb-cell-name*="cbParamVirtualX"] { color: red !important; } </style> You may refer to this post for getting the Form Elements: I hope it helps!
  17. You can check Caspio's article about password options here: https://howto.caspio.com/datapages/datapage-components/field-configuration-options/password-options/
  18. You could change it to this. <style> td[class*="cbResultSetData"]:nth-of-type(9){ color: red !important; } </style>
  19. You may refer to this forum post as a reference: then change it to this code: <style> [class*=cbResultSetHeaderCell]:nth-child(9) a { color: red !important; } </style> a is for the href attribute and color is for the text of it. I hope it helps!
  20. Hi @rgiljohann, Just an update! You can now use Calculated Value in Details Page and Update forms! Check it here: https://howto.caspio.com/release-notes/caspio-bridge-17-0/
  21. Hi @Duncan, You can refer to this Forum post about Timestamp and time difference. I hope it helps.
  22. The ID Elements will depend on the DataPage you are using. You can this post for more information:
  23. Hi @sunsensesolar, Just an update: You could use the Calculated Values on this one. Calculated Value form element generates dynamic calculations that automatically update as users interact with your form. Similar to Formula Fields and Calculated Fields, you can construct the calculation using functions, logic, constants, values from other fields and SQL expressions that you can use in Virtual Field then put it in HTML Block. After that, you can hide the Virtual field itself. For more information about Calculated Values, check this article: https://howto.caspio.com/datapages/datapage-comp
  24. Hello @logistics, Just an update: You can use the Calculated Values. Calculated Value form element generates dynamic calculations that automatically update as users interact with your form. Similar to Formula Fields and Calculated Fields, you can construct the calculation using functions, logic, constants, values from other fields and SQL expressions to use in your Virtual Field. For more information about Calculated Values, check this article: https://howto.caspio.com/datapages/datapage-components/calculated-values/ Hope it helps!
×
×
  • Create New...