Jump to content

Barbie

Caspio Guru
  • Content Count

    137
  • Joined

  • Last visited

  • Days Won

    4

Barbie last won the day on November 1 2020

Barbie had the most liked content!

1 Follower

About Barbie

  • Rank
    Advanced Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Barbie

    Custom symbol

    You can set the custom symbol or icon by just copying and pasting it on the Yes and No custom field. You may refer to this sample screenshot. For the symbols, you can refer to this article: https://unicode.org/emoji/charts/full-emoji-list.html - Barbie
  2. Hi @Batchini Yes, here's a sample task which you can refer to: - Barbie
  3. Here's an article which you can refer to for more information about SQL functions: https://howto.caspio.com/function-reference/
  4. In addition to my last response, you may want to go over these article for more info: https://howto.caspio.com/tables-and-views/triggered-actions/ https://www.caspio.com/webinars/introduction-to-triggered-actions/
  5. Hi @Batchini, If you want to display the data for the current week only, you can use this sample fiormula as reference: (SELECT SUM(Paid Field) From Amount_tbl WHERE Agent_Number = target.[@field:Agent_Number] AND Date >= dateadd(day, 1-datepart(dw, SysDateTime()), CONVERT(date,SysDateTime())) AND Date < dateadd(day, 8-datepart(dw, SysDateTime()), CONVERT(date, SysDateTime()))) - (SELECT SUM(Amount_owed) From Amount_tbl WHERE Agent_Number = target.[@field:Agent_Number] AND Date >= dateadd(day, 1-datepart(dw, SysDateTime()), CONVERT(date,SysDateTime())) AND Date < datea
  6. Hi Johan, I believe this can easily achieve using Triggered/Task. You may refer to this article for more information: https://howto.caspio.com/tasks/ https://howto.caspio.com/tables-and-views/triggered-actions/ - Barbie
  7. Hi, You may also refer to this article for more detailed information about the SQL functions: https://howto.caspio.com/function-reference/ - Barbie
  8. In addition, you may refer to this forum post for hiding fields using Javascript code: - Barbie
  9. I encountered the same issue before and I believe the main reason why the issue happens is that the code you are using for the collapsible is having a conflict with our Rules. One of the possible solutions that you can do is to use JavaScript if you're familiar with that to hide these fields based on a condition. - Barbie
  10. Hi Batchini, I believe this can be done using triggered action. here's my sample Trigger similar to what you're trying to achieve: I hope this helps. - barbie
  11. Hi @Batchini, Just to add, you can refer to this article for more information about Case When and a sample formula: https://howto.caspio.com/function-reference/ - Barbie
  12. In addition to the response above, you may refer to this article for more examples and function explanations: https://howto.caspio.com/function-reference/ - Barbie
  13. Hi @Batchini glad that it worked on your end. Make sure that you have a matching field in both tables. Assuming that the Child table is your table two where you wanted to update a field. - Barbie
  14. Hi, I believe this article will help you with your current workflow as well: https://howto.caspio.com/tech-tips-and-articles/common-customizations/create-user-specific-redirect-after-login/ - Barbie
  15. Hi @Batchini, I think the '=' is used for assigning a value in a variable and the '==' is used for comparing two variables. You may also refer to this article that I searched: https://stackoverflow.com/questions/523643/difference-between-and-in-javascript I hope this helps. - Barbie
×
×
  • Create New...