Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


NiceDuck last won the day on March 2

NiceDuck had the most liked content!


About NiceDuck

  • Rank
    Advanced Member

Recent Profile Visitors

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

  1. such kind of error will normally not occur if you only have an email block inside your trigger. As mentioned by @CoopperBackpack, do yuo happend to have a unique field on table? You may also want to check on other tables where that is being mentioned or referenced by your current trigger.
  2. You may not need it now but you can also create one for delete action. Please note that there can only be 1 triggered action enabled per action. So if you have two triggered action for insert action, enabling 1 of them will automatically disable the another.
  3. We can indeed do this via Triggered Action. If I got it correct, you want to get the average value from specific field, starting from the total value of all the records on the table as well as the value of the newly inserted. Then save the computed average to another field on the newly inserted. If that is the case, you can normally use a trigger like this:
  4. As I know, the formula comes first before the trigger since it automatically produce value once the record is created even though they are still on the #inserted. As for why your workflow does not work, may you please give me a screenshot of trigger as well as the formula you are using?
  5. You may want to check our discussion here as well:
  6. As a follow up to @AtayBalunbalunan's comment, if its on triggered action or task, removing the block that reference the field on the structure or just disabling it will not suffice, you will have to completely delete those blocks that mentions the field you want to delete or atleast modify it so it will refer to other fields instead.
  7. On this case, you will only need to replace the table reference of your triggers. Instead of using the Table name, you will have to use the #inserted Instead. By the way, the trigger must be on the actual table where the activity occurs and not on the table referenced. If you could provide me a screenshot of your trigger, perhaps I can point out exactly what needed to be changed.
  8. You may also try creating an autosubmit submission form that will manually submit the records to your intended table. For this workflow, you will need to create a submission form for the intended destination table. Make sure that this submission form is capable of capturing values from external parameters. Then on your actual DataPage, create a links (preferably those that create pop-ups when clicked) to the submission form that you just made. Make sure that you include the values you want to pass to the another table as an external parameter to the URL you use on the link
  9. Depending on how do you want it to work actually. We can try using triggered action. What you will need to do is to add an extra field (preferably a yes/no field) on your main table data source. Include it then on your Datapage then perform an inline edit where if the user checked the yes/no field, it will be copied or transferred into another table which you intended. You will need a trigger like this in order for that workflow to work:
  10. Hello! If I got your inquiry correct, base on the value of your key_code field, you want to automatically assign a value to your hidden group field which base on a lookup table. In short, if the keycode is equal to X1, then the hidden field should have a value of Group1. Is that the case? If yes, we can also use calculated value on your form on that case. Just set your group field into calculated value then use either a switch case formula or select formula to get the intended value base on the value of key code. example formula Case when [@field:Key_code] = 'X1' then 'Group1'
  11. Do you have a field there on either one of the table involves that can be used to Identify if the record is an ICT Job? If yes, just add another conditional statement on the where clause for that filter.
  12. I think I have the issue now, do you mean that you want to update the date of the record on your table b (parent Loans table) with the latest date from your table a (Payments table) including the one you just inserted. However, what happens is, your select top 1 from payments table does not detect the record you just inserted. Is that the case? If yes, that is indeed because the record you just inserted is not yet on the table yet during the trigger operation. They are actually on a virtual table called #inserted. They will only be an actual member of that table right after the trigg
  13. BAse on your workflow, all of them will be users with different roles. I suggest for this case that you just use a single table and mark each users depending by role. Then you can use the suggestion of @SinJunYoung to seperate them later via view with then with their own authentication. The reason about this is because you may want to create a single login portal for them then just redirect them based on their user level. Even if each of the user levels has their own authentication and view, as long as their root table (which you will use as the data source of your authentication at the por
  14. I think I got it now. You will need to save it first after changing the Data Type of the field to list-string then edit it again for importing the list-string values. Doing them on the same time will cause an error.
  15. There is an issue that I have encountered just few days ago where I am converting a text255 field into a list-string field then importing values for it from a different table. It kinda works well but it gives this error when you save it: Any ideas?
  • Create New...