Jump to content


Caspio Rockstar
  • Posts

  • Joined

  • Last visited

  • Days Won


NiceDuck last won the day on December 16 2021

NiceDuck had the most liked content!


Recent Profile Visitors

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

  1. It is possible with a more complex triggered action. The workflow varies from time to time but the basic Idea is something like this: First, on the table where you are saving the logs, you will need to have an extra field that will specify which change occur. Then, you will need a block like this for every single field: I hope this helps.
  2. I use a reverse approach on my case. On my actual records, I have a textfield there that contains the ID of the users that are allowed to see them. then from the datapage level, I take the current user's id and use a 'contains' operator to check if the current user's id is in the compilation of ID for that record.
  3. Hello, The task should be accessible only to admin accounts, it is kind of all or nothing. Anyway, in what browser did you encounter the error?
  4. You may also want to make sure that the email you used on the 'From' field is a valid email address.
  5. We cant send files on triggers. The common workaround is to create a datapage where they can download the file and send the link to them via trigger.
  6. Do you have hidden fields that are set as required? like required fields that relies on parameter for values? Perhaps missing parameters may be causing the issue.
  7. Just as @kpcollier provided, you'll need something like this: Are you trying to make your own unique ID or something?
  8. My idea on this one is I'm going to create a hidden calculated value with a query that checks all of those checkbox 1 by one. Like case when [@field:check1] = 1 then 1 when [@field:check2] = 1 then 1 . . . end With this, if none of them is checked, the calculated value will return blank which will then prevent submissions.
  9. Depending on what you are trying to do, I would suggest that you just use your trigger to collect the data and store them on fields then you use an actual formula field to do the computation for you. With that, you can control your formulas better than the blocks on the trigger.
  10. We can also use task here. But I would advice that only if you need to do this on multiple table at once...
  11. Hello, I have seen this as well. The variable cant hold hat much characters. So far the only solution I came up with is to make sure that the characters wont reach more than 3k. The other Idea I have is to use a table variable instead and insert the values there, then use it on the email.
  12. I tend to avoid using if then blocks and In/not in statement. I'm not sure as well but they tend to file sometimes. On cases like this, Id rather use multiple blocks with redundant where clauses. Id rather use 'exist/not exist' as well instead of in and not in. They are a bit confusing at first but they never failed me so far.
  13. Halo, The solution I know for this one is to use a separate search and report just like on this article: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/ On the form you are using for search, just create a single search field there. As for the actual report, make the multiple columns received the single parameter from the search form. On that way, they will also refer to the value of that single search field.
  14. I remember creating a setup where each companies has a text255 or text64000 field where I collect all userID of the users allowed to see them via CSV. Then on report datapage, instead of using RLS, I create a hidden search field that will check if the list of ID field (which I mentioned above) contains the current user's ID.
  • Create New...