# PotatoMato

Caspio Guru

140

2

1. ## Error in formula

Hi, just to update this post. You may also check this how-to article regarding the causes of 'error in formula' message: https://howto.caspio.com/troubleshooting/errors-and-messages/
2. ## Calculation error despite valid formula

Hi, just to update this post. You may also check this how-to article regarding the causes of 'error in formula' message: https://howto.caspio.com/troubleshooting/errors-and-messages/
3. ## Error in Formula

Hi, just to update this post. You may also check this how-to article regarding the error in formula: https://howto.caspio.com/troubleshooting/errors-and-messages/
4. ## Changing the value name of a database field

Hi! Just to update this post. You may refer to this forum post:
5. ## Add icons to form fields

Hi! Just to update this post. You may also refer to this video tutorial regarding custom symbols:

Hi! Just to update this post. You may also refer to this video tutorial regarding custom symbols:
7. ## Show icon on a tabular report based on condition

Hi! Just to update this post. You may refer to this forum post:
8. ## Check Mark For Yes Value On Report

Hi! Just to update this post. You may also refer to this video tutorial regarding custom symbols:
9. ## Formatting Yes/No Field in Database

Hi! Just to update this post. You may also refer to this video tutorial regarding custom symbols:
10. ## Error converting data type varchar to float

Just to add, you may also convert the result of 'then' to text. For example: Case When ([@field:ItemPrice]) > 500 and([@field:ItemPromo]) = 'Half Price' then CONVERT(VARCHAR,([@field:ItemPrice]/2)) else 'Original Price' End -Potato
11. ## Text and numeric values in calculation

Hello, @Sam23! If you wish to change the date format, you may use the formula below. CONVERT(DATETIME,[@field:K2_Contact_Birthday],110) For list of different format, you may check this link: https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/ -Potato

Hello! Just to add here, Caspio has already released 'Document Generation'. You may now create your own fillable PDF template. Refer here: https://howto.caspio.com/release-notes/caspio-30-0/ -Potato
13. ## Emails via triggers are being flagged as Junk/Spam

Hi @MarkMayhrai, you may want to check this How-to article: https://howto.caspio.com/troubleshooting/troubleshooting-notification-emails/. Hope this helps! -Potato
14. ## Rating System...1-5 Stars Display Perfectly, But Graphic For Zero Stars Will Not Display

Hi! Just to update this post. Star rating is available on Caspio's app extensions. You may check this link: https://www.caspio.com/services/app-extensions/ and go to UI controls. -Potato
15. ## How can I limit user to one use of a data entry form?

Hi! Just to update this post. You may check this How-to article to limit the submission/voting once a day: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-limit-the-number-of-submissions/ -Potato
16. ## Tabulating Vote-Type Selections In A Report

Hi! Just to update this post, you may check this How-to article for your workflow: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-create-vote-up-and-vote-down-for-individual-records/ -Potato

19. ## How to move the the text field and search button to the right side

Hi! Just to update this post. Caspio has already created a How-to article for this. You may check this link: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/display-the-submit-or-search-button-inline/. -Potato
20. ## Static Image beside the form

Hi, just to add, you may also check this How-to article: https://howto.caspio.com/tech-tips-and-articles/common-customizations/tech-tip-5-ways-to-customize-the-look-of-your-datapages/ -Potato
21. ## Bootstrap Classes in Caspio

Hi, just to update this post, you can also check this forum post regarding Bootstrap:
22. ## Reports Dashboard

Hi, just to update this post. Caspio has already release a video on how to create dashboards. You may check it here:

Hello, just to update this post. You may use the formula below: DateAdd(day, 15 +(15 / 5) * 2, [@field:Date_field]) 15 is the business days that will be added to the date field. You may also use an actual field. -Potato
24. ## Auto format a phone number field javascript

Just to update this post. Caspio has already created a How-to article for this. You may check this link: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/format-phone-number-in-datapages/ -Potato
25. ## move submit button inline

Just to update this post. Caspio has already created a How-to article for this. You may check this link: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/display-the-submit-or-search-button-inline/. -Potato
×