Hi, I am trying to create a table form that gets pre- populated when choices are made from a few drop down menus. They would click a button to create a form and is prompted to select a category and specify the month and year and when submitted a editable table that auto populates the fields along with the month and year field based on the previous step. So if the category selected has 5 things linked to it, it will create a table with 5 rows with those 5 things and the month and year gets filled down in their respective column. Hw can I approach this? Will I need two datasource, 1 for lookup and one to store the entries?
Example:
Chosen Category: A
Chosen Month: Dec
Chosen Year: 2020
then after submitting the editable table is navigated to.
| Category | Items | Month | Year | Qty |
| A | Pen | Dec | 2020 | |
| A | Pencil | Dec | 2020 | |
| A | Marker | Dec | 2020 | |
| A | Crayon | Dec | 2020 |
then a empty column for user to enter data.


Report
All responses (
Answers (