I have a list of project ID's. Each project ID has multiple app ID's. I need to create a form that list each app id as a field name so the user can submit allocation to each app id on the project level.
Currently, I have a list that has every app on a single row making it difficult to add up the distribution. There are many projects and many applications that will be filled out so ideally, I would like to create a form that can open one project and display all the app ID's and also allow the user to fill in the allocation. Is this possible?
Project ID - App ID - Allocation 1 A 50 1 B 50 2 C 33 2 D 33 2 E 33