Harpreet Posted October 17, 2022 Report Share Posted October 17, 2022 I have a data page which will be filled by user as a date range. For eg: User selected start date and end date, and name, address, vacation. Expected outcome: The date range should split all the dates and other column in new rows. Is this type of trigger possible. Eg: Webform----------Start date: 10/1712022 , End date 10/20/17, Name: Harpreet, Address: Toronto, Vacation : British Columbia Expected Result Data page : Date Name Address Vacation 10/17/2022 Harpreet Toronto British Columbia 10/18/2022 Harpreet Toronto British Columbia 10/19/2022 Harpreet Toronto British Columbia 10/20/2022 Harpreet Toronto British Columbia Quote Link to comment Share on other sites More sharing options...
0 Wikiwi Posted October 17, 2022 Report Share Posted October 17, 2022 You can achieve this using a small triggered action and a dummy table that will accept the input from your DataPage and will contain the trigger that will create all the records of date range. Trigger in the dummy table: Sample input in dummy table: Output to main table: Quote Link to comment Share on other sites More sharing options...
0 Flowers4Algernon Posted October 22, 2022 Report Share Posted October 22, 2022 Hi! This how-to link may be also helpful as you go along: https://howto.caspio.com/tables-and-views/triggered-actions/ Quote Link to comment Share on other sites More sharing options...
Question
Harpreet
I have a data page which will be filled by user as a date range.
For eg: User selected start date and end date, and name, address, vacation.
Expected outcome: The date range should split all the dates and other column in new rows. Is this type of trigger possible.
Eg: Webform----------Start date: 10/1712022 , End date 10/20/17, Name: Harpreet, Address: Toronto, Vacation : British Columbia
Expected Result Data page :
Link to comment
Share on other sites
2 answers 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.