Jump to content
  • 0

Triggered Action or Formula field




Didn't exactly know where to put this one, so sorry if this is in the wrong place. 

I'm new to Caspio so perhaps this is a noob question, but please help me out and thanks for reading anyway :)

I've got a table which has a couple of date fields for the weekdays. A workday starts on monday and the user can select which mondayDate that is .

I would like to add the date of monday + 1 day to the field TuesdayDate and so on for the other days. So if a user selects 01 januari 2017 as date for monday, the field TuesdayDate = 2 januari 2017 etc.

I thought i could do that via a tabel/formala field where TuesdayDate = DATEADD (dd , 1, [@field:MondayDate] ) but when i use  this the formula field doesn't show up any more in my Submission DataPage.

So perhaps via a triggered action, where i used an insert and update action when the field MondayDate is not empty then fill the TuesdayDate as the value of Monday + 1 day. But i'm doiing something wrong cause when i validate no problem but when i try to enable this i get an error concerning nesting level 1. 


Do you have any idea how to approach this ? I added a screenshot of the triggered action 






Trigger Action.PNG

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...