-
Content Count
2 -
Joined
-
Last visited
Posts posted by bp999
-
-
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
Triggered Action or Formula field
in Tables, Views and Relationships
Posted
I talked to Support, and they helped me out, I've made a table with weeks, days and date and via the Datapage used a cascading dropbox.
So this question is closed for me.