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