Jump to content

NailDyanC

Caspio Rockstar
  • Posts

    394
  • Joined

  • Last visited

  • Days Won

    9

NailDyanC last won the day on June 22

NailDyanC had the most liked content!

3 Followers

Recent Profile Visitors

921 profile views
  1. 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 "+".
  2. 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/
  3. 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])
  4. 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
  5. 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]))
  6. Hi, Here's another way to extract the "Code" text in your feild: SUBSTRING([@field:Code_Description],0, CHARINDEX('_',[@field:Code_Description]))
  7. 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.
  8. 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/
  9. 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:
  10. Hi, just to add in the previous comments above, you may also consider checking these video tutorials about user redirection:
  11. Hi, just to update this post and add in the previous comments above, you may also consider checking these links: https://forums.caspio.com/topic/19994-dynamic-progress-bar/?tab=comments#comment-56794 https://forums.caspio.com/topic/6492-progress-bar-needed/?tab=comments#comment-20304 https://forums.caspio.com/topic/4559-progress-bar-during-submission/?tab=comments#comment-14320
  12. Hi, just to add in the previous comments above, you can also have a field and set the form element of that field to Calculated Value so that you can store/save its result to the table. In a addition as well with to the triggered action workaround, you may consider checking this video:
  13. Hi @JayDub, that is good to know. However, one problem with it is once you will print/view it in a PDF format, it will only print the first page even if you still have another page for some records. My solution to that is to maximize the number of records that will show in your tabular report so that it will be included in one page printing of your details page.
  14. Hi, just to add to the previous comment above and update this post as well. You may also try this other workaround:
  15. Just to add in the previous comment above, you may also consider checking this link on how to hide fields: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/
×
×
  • Create New...