Create rows in 2 different collections in a form

Ask the community
, ,
1

Hello,
first sorry for my english, I’m french but I’ll try to be as understandable as possible :wink:

I have 3 collections for a website :
-ConstructionsList : for a list of constructions sites that members have registered by a FORM A
-Tools : for a list of tools (with name of tool and category of it)
-PossessedTools : for list of tools possessed by each members

Here is my issue :
I have a form (FORM A) which allow members to create a construction site. The submit button update the ConstructionsList collection for now.
Now I want to add an information in this form, which show the tools list (which are in the Tools collection) and I want to allow members to check the tools they own, in order to add this information in the ConstructionsList collection AND in the PossessedTools collection at the same time.
I want to do that because I want to show in a page which tools are available for a construction site, and another page what tools a member have.

In the Tools collection, I put the ToolName field as primary key and in the PossessedTools collection, I put ToolName field as reference to the same field in Tools collection.

My question is : how can I configure my form to do this? And do I have to add a special field in the ConstructionsList collection (a reference field too? Because there will be several tools available for each constructions site !)?
I’m a beginner in wix code and I don’t know which function to add to the form…

Thank you
Fabien.

2

Hi Fabien!

Indeed, reference fields could do the work. I’d suggest you to read this article .
There’s a part specified for showing data from multiple collections.

Hope it helps.

Doron. :slight_smile: