Jump to content

NailDyanC

Caspio Rockstar
  • Posts

    409
  • Joined

  • Last visited

  • Days Won

    11

Everything posted by NailDyanC

  1. Just to add in the previous comments above and to update this this post. You may consider checking this article on passing of parameters using query string: https://howto.caspio.com/parameters/parameters-as-query-string-values/
  2. Hi just to add in the previous comments above, here are some documentations that was sent to me by some support members of Caspio about best practices and guidelines to make your application better: https://howto.caspio.com/tech-tips-and-articles/common-customizations/tech-tip-optimize-your-web-forms-for-maximum-usability/ https://howto.caspio.com/tables-and-views/table-and-database-design/ https://howto.caspio.com/datapages/best-practices-in-creating-caspio-applications/
  3. Hi, just to update this post. This is the working and updated link for creating a separate search and result: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/
  4. NailDyanC

    Weighted Average

    Hi just to add some information and to update this post, you can only use the SUM function in Aggregation. You may check this link for more details and to see other formulas you can use inside Caspio: https://howto.caspio.com/function-reference/
  5. Hi, just to add in the previous comment above if you would like to remove apostrophes (') or use it in your formula, you may use 'char(39)' as an alternative for that symbol. Like for example: CHARINDEX(char(39),[@field:Fieldname])).
  6. Just to update and add some additional information to this post, what he mean for nested replace function is there is a replace inside a replace function. So the formula should look like this: (replace(replace([@field:First_Name],'!',''),'$',''))
  7. Hi, just to add in the previous comments above, phone formatting is also possible using calculated fields, calculated values or even in Formula fields. You may use this formula: CASE WHEN [@field:Phone_Number] != ' ' THEN '(' + SUBSTRING([@field:Phone_Number], 1, 3) + ') ' + ' ' + SUBSTRING([@field:Phone_Number], 4, 3) + '-' + SUBSTRING([@field:Phone_Number], 7, 4) ELSE [@field:Phone_Number] END
  8. Hi, just to add in the previous comments above, phone formatting is also possible using calculated fields, calculated values or even in Formula fields. You may use this formula: CASE WHEN [@field:Phone_Number] != ' ' THEN '(' + SUBSTRING([@field:Phone_Number], 1, 3) + ') ' + ' ' + SUBSTRING([@field:Phone_Number], 4, 3) + '-' + SUBSTRING([@field:Phone_Number], 7, 4) ELSE [@field:Phone_Number] END
  9. Hi, just to add in the previous comments above, phone formatting is also possible using calculated fields, calculated values or even in Formula fields. You may use this formula: CASE WHEN [@field:Phone_Number] != ' ' THEN '(' + SUBSTRING([@field:Phone_Number], 1, 3) + ') ' + ' ' + SUBSTRING([@field:Phone_Number], 4, 3) + '-' + SUBSTRING([@field:Phone_Number], 7, 4) ELSE [@field:Phone_Number] END
  10. Hi, just to add in the previous comments above, this phone formatting is also possible using calculated fields, calculated values or even in Formula fields. You may use this formula: CASE WHEN [@field:Phone_Number] != ' ' THEN '(' + SUBSTRING([@field:Phone_Number], 1, 3) + ') ' + ' ' + SUBSTRING([@field:Phone_Number], 4, 3) + '-' + SUBSTRING([@field:Phone_Number], 7, 4) ELSE [@field:Phone_Number] END
  11. Hi, just to add to the previous comments above, you may use a calculated field/calculated value to check if the value/record is already existed in the table using this formula: CASE WHEN (SELECT COUNT(FIELDNAME) FROM TABLE WHERE CODE=target.[@field:CODE) > 1 THEN 'EXISTING' ELSE 'NOT EXISTING' END And, you may create now a JavaScript code that will display an error based on the result of the calculation. I hope this helps.
  12. Hi just to update this post and add to the previous comments above, you can convert your trial account to a free account however, there are features that are available in the Trial version that are not included in the Free Version. As I contacted one of Caspio's support member, they say that Trial version is much more like the Grow plan that they currently have with it comes to features and Free version is much more different from it. So there might be some issues you may encounter once you convert your trial to a free account.
  13. Hi, here's the new update about Caspio's new version release which is 28.0: https://howto.caspio.com/release-notes/caspio-bridge-28-0/
  14. Hi, here's the new update about Caspio's new version release which is 28.0: https://howto.caspio.com/release-notes/caspio-bridge-28-0/
  15. Just to update this post and add a comment from the previous comment above, you may also try using Calculated value in your submission form to calculate data entries. You may check this link for more details: https://howto.caspio.com/datapages/datapage-components/calculated-values/
  16. Hi, just to add in this comment, you may also consider using CONVERT function. 'USER' + CONVERT(VARCHAR, [@field:UserID]). If you would like to put spaces between the two, you may use this function: + ' ' + instead of using the "+".
  17. Hi, just to update this post and add to the previous comment above, you may also consider checking this article from Caspio on hiding fields: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/
  18. Hi, just to update this post and add in the previous comment above. Yes, by default we cannot call a formula field inside a formula field however you can copy the whole formula that you have in your other formula field so that it can still perform the calculation that you would like. For example: Formula 1: [@field:field1] + [@field:field2] Formula 2: [@field:field2] + [@field:field3] In your other formula field you can use the following formula; ([@field:field1] + [@field:field2]) / ([@field:field2] + [@field:field3])
  19. Just to update this post and add in the previous comment above, you may use CASE STATEMENT on this workflow: CASE WHEN [@field:Dropping_Unit] != ' ' THEN SELECT COUNT(Dropping_Unit) FROM CH_tbl_Base WHERE District= target.[@field:DistrictName] ELSE 'Your other condition when the field has blank values' END
  20. Hi, As I understand your workflow, you want to extract the text "Code" in the word "Code_Description", right? If that is the case, you may try this formula: SUBSTRING([@field:Code_Description],0, CHARINDEX('_',[@field:Code_Description]))
  21. Hi, Here's another way to extract the "Code" text in your feild: SUBSTRING([@field:Code_Description],0, CHARINDEX('_',[@field:Code_Description]))
  22. Hi, just to update this post. It seems that the function that you will need is "Right(string,length)"since you will be getting the last number from the right which is 5. You may consider this workaround: Right((CONVERT(VARCHAR, ([@field: Fieldname]))),1) Just change the field name based on the calculated field that you are using.
  23. Hi, just to add in the previous comment above, it seems that this workflow is possible using Triggered Actions. You can simply add a field(like a checkbox) at the end of your submission that once it is click then a trigger will fire to send an email. You may check this link about triggered actions: https://howto.caspio.com/tables-and-views/triggered-actions/
  24. Hi, just to update this post and add to the previous comment above, you may consider checking this link about restricting values to be number only:
  25. Hi, just to add in the previous comments above, you may also consider checking these video tutorials about user redirection:
×
×
  • Create New...