I’m trying to build a multi-step form for adding products, where users fill out product details, then move to sizes(sizes can be one or can be more than one), and finally to colors (each size has few colors) — all linked to the same product.
I have followed this thread and read it before posting my question. While creating a multi-step form with a table of data is straightforward, it becomes more challenging dealing with multiple data tables linked to a parent something goes wrong with me or I can’t understand, how to link them to the same product ID or Row ID that I am filling currently.
Here are some screenshots. I’m not sure if my idea is clear yet, but let me know if you need any further clarification.
What I’m currently stuck on is how to pass the captured data from one screen to another, ensuring that the sizes are correctly assigned to the product I’m filling out.
Now you just need to have a custom form per the linked thread.
Add a table with only one row that serves as your place to hold temporary values. Let’s call this “Helper Table”.
Add user-specific columns to hold user’s choices for product, size, color and quantity details.
In the table of the screen you’re adding the form button, add a single value > whole row column pointing to the “Helper table”. This is our path to the custom form screen.
Add a “Show details screen” button and point to the single value result above, also use a “Set column values” on top of that single value and clear all inputs in the Helper Table.
In the details screen, start planning your multi-step form. In the first screen, add a choice component for products, and a button to move to the next step, available only when product ID is not empty. This button will be “Show new screen > This item”.
In the second step, add a choice component for sizes, filtering the available choices to “Product ID Row” is this row > “Product ID”.
Do that until the last step, add a button to add a row to the Form Responses table and complete the form experience.
Or if you don’t want too many steps to go back, you can have a user-specific Steps counter that increments by 1 each time the user moves to the next step, and structure component visibility around it.
Thank you for your clear explanation, it really helped me understand the structure better! However, I’m still stuck on two points:
Multiple Sizes for the Same Product:
How can I add more than one size for the same product code? As you can see in the attached image, I tried adding a row and setting values, but the fields kept updating the first entry instead of allowing multiple entries for the same product.
I am not sure if my way is the best to do that but I’ve tried my best.
Viewing Recorded Sizes:
I also attached the fields I entered in the last stage. Is there a way to display all the sizes I’ve recorded? I’d like to show them as a list or table under the product details.
At that stage, I think you should have a form container on the screen instead. That will write the product ID, the size, the price and the size code template to the Sizes table.
Once you submit that, it will clear the entries so you can submit another one.
Create a multiple relation using the Product Code that you have in your form to the sizes table, where you should also store the Product Code.
I guess what is throwing you off here is you don’t have a “Product ID Row” yet when you’re doing it this way, but if your product code is unique, you can use that as well.
Otherwise, set a unique value to a user-specific column in the custom form to serve as your product ID, and then use it the rest of the way.
My Ideal Workflow:
Challenge:
If anyone has solved this or knows a workaround, please share! Any help would be greatly appreciated! 
