Hi Appsheet community,
I have a table called: Projects, and another table called Assets. In the table Projects i can create a new project and ref to assets that are a part of this project. In the Table Assets a store all my rooms which are all unique. In a detail view of a asset i can see all related projects that this asset has been a part of.
This was created using a table in the middle called: Project_Assets. This table holds a project ID and a Asset ID.
So far so good,…
Problem to solve:
Situation now: When i create a new project, and want to ref to 10 related assets, i have to add all assets one by one.
When a new project is created i want to multi select different assets at once.
Idea on how to achieve that: in a table view of the table assets, with the function “Quick edit” on. I want to multi select different assets and execute an action: an action where i wright the asset ID on the related middle table: Project_Assets. problem here is that the project ID is not created at the time this action is executed…