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
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.
Question
bp999 0
Hi,
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
Thanks
Bart
Link to post
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.