Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Barbie

  1. Hi @Batchini Can you try this formula instead: IsNull([@field:Field1], 0) + IsNull([@field:Field1], 0) I just added IsNull function. What it does is it replaces NULL with the specified replacement value, otherwise returns the result of expression. You may refer to this article as well. https://howto.caspio.com/function-reference/ - Barbie
  2. Hi @Batchini, It is not possible to add a condition in the email notification on DataPage level. What you can do is to create a Task that will run everyday to check your records that if the difference of today's date and the date created inside your table is equal to 3 then it will send an email. Please refer to this sample configuration: I hope this helps. - Barbie
  3. Here's a video as well for better understanding and visualization about triggered actions: - Barbie
  4. For more details about calculated fields you may check these links: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ https://howto.caspio.com/function-reference/ - Barbie
  5. Hi, in addition with my response above, you may refer to this link for more infomration about formulas such as Case When and Select Statments: https://howto.caspio.com/function-reference/ - Barbie
  6. In addition, you can refer to this article for more informtion about formula: https://howto.caspio.com/function-reference/ - Barbie
  7. You may also refer to this article for more information: https://howto.caspio.com/function-reference/ - Barbie
  8. Hi @JayDub, your workflow might need custom coding such as JavaScript. Here's a link which you can refer to for the JavaScript code: I hope this helps. - Barbie
  9. Hi @Batchini, What we can do to achieve your current workflow is to insert an HTML Block instead and call the File Field there as a link. You may refer to this screenshot: Here's the HTML code for the link download: <a download='file' href="[@field:File_field/]"> Download Image </a> Please note that you need to change the [@field:File_field/] based on what field do you have. I hope this works now. - Barbie
  10. Hi @frank99, One solution that I can suggest is to use the month and year in the Date rollup. In this case, the data from different months and years will be separated. Please refer to this: And here's an article for reference: https://howto.caspio.com/datapages/charts/ I hope this helps. - Barbie
  11. Hi @drmt1979, If you want it to be editable, you might need to add a simple JavaScript code for you to achieve that. Please refer to this forum post: https://forums.caspio.com/topic/7002-use-timestamp-as-default-value-of-a-text-field-in-a-details-page/?tab=comments#comment-47842 Hope this works. - Barbie
  12. Hi @databydesign, If you want to hide a field if the Yes/No field is unanswered in a details page, you can use the Rule feature. You can refer to this article for more info: https://howto.caspio.com/datapages/forms/conditional-forms/ I hope this helps. - Barbie
  13. Hi, Just to add, you can also check more information here: https://stackoverflow.com/questions/3715675/how-to-convert-float-to-varchar-in-sql-server https://howto.caspio.com/function-reference/
  14. Hi, You may also want to check this video for more information: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ - Barbie
  15. Hi, You can use the formula below to concatenate these two: CONVERT(VARCHAR(10), [@field:FieldA], 101) + ' ' + CONVERT(VARCHAR(10), (DatePart(year,[@field:DateField])), 101) I converted these fields to text so that they can concatenate as two different fields instead of having a sum as a result. - Barbie
  16. Hello @Batchini, what you can do is to have a concatenation with Case When statement inside your email body. Here's a sample Task that I created on my end: Assuming that the 'Currency' field is the field that contains a negative value. The assigned '10' in length is the maximum length of your value. You can change that based on what length do you prefer. I hope this works on your end. - Barbie
  17. Hello @Batchini, If it is on the Table level, can you try to use the formula below for converting a number to a string instead?: LTRIM(STR([@field:FieldA], 25, 0)) + LTRIM(STR([@field:FieldB], 25, 0)) + '.docx' It seems like the main reason why it is displaying the incorrect result is that the value you're trying to convert exceeds the max size value. I hope this helps. - Barbie
  18. Hello @KAPITYAN, If you're using a submission form, you can try to use this formula instead: CASE WHEN [@field:Stack] = 1 AND [@field:Lucy] = 0 AND [@field:Edward]= 0 AND [@field:Sebby]= 0 AND [@field:Maria] = 0 THEN 'Stack' WHEN [@field:Lucy]= 1 AND [@field:Stack] = 0 AND [@field:Edward] = 0 AND [@field:Sebby] = 0 AND [@field:Maria] = 0 THEN 'Lucy' WHEN [@field:Lucy] = 1 AND [@field:Stack] = 1 AND [@field:Edward] = 0 AND [@field:Sebby] = 0 AND [@field:Maria] = 0 THEN 'Stack , Lucy' WHEN [@field:Lucy] = 1 AND[@field:Stack] = 1 AND [@field:Edward] = 1 AND [@field:Sebby] = 1 AND [@field:Maria] = 1 THEN 'Account Manager' END I hope this works now. -Barbie
  19. Hi, Just to add, you can also add (*) in the [@cbTimeStamp] if you want to get the date only. You should use this: [@cbTimestamp*] I hope this helps. -Barbie
  20. Hi @Batchini I can see that already asked this question. Here's the solution I provided on the other forum post which is same by this: https://forums.caspio.com/topic/16790-passed-parameter-based-on-a-condition/#comment-45906
  21. Hi @Batchini, It might be having an issue with the quotation mark on the a href value. What you can do is to add a Virtual field that will display the link and paste the code below: CASE WHEN [@field:FieldName] = '1' THEN '<a href=' + '"' + 'https://nameofyoursite.html' + '?name=[@field:name]'>Link1</a>' ELSE '<a href='https://nameofyoursite.html'>Link2</a>' END I hope this works. - Barbie
  22. Hi @Batchini, By the way, you can also refer to this article for more information about styles: https://howto.caspio.com/styles/ - Barbie
  23. Hi @Batchini, I understand that you wanted to store the records from table 1 to table 2 if the ID is not existing in table 2. You can refer to this Task configuration that I have created: Again, with this configuration, let's assume that the Child_tbl_ is the 'Table 2' and the 'Parent_tbl' is the 'Table 1. The records will be inserted in table 2 if the ID of the records from Table 1 does not exist on this specific table. I hope this works! - Barbie
  24. Hi @AccessNerd, In addition to what I mentioned above, you may consider using Rules as well which will check what is the role if the user who's logged in then you can configure which section you want to hide. But Rules is only applicable in Submission and Details DataPage. Please refer to this article: https://howto.caspio.com/datapages/forms/conditional-forms/ - Barbie
  25. Hi @AccessNerd, You may want to check this article: https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/restrict-access-to-data-by-user-or-role/ Also, you need to add multiple app parameters base on what you want to display. I hope this helps. - Barbie
  • Create New...