how to fetch data from another worksheet ...

Hi,

I’m creating an inventory for my company, but I’m having some difficulty with an issue

I have an inventory page with all the materials in the company, and I have another page that is the events, the idea is to create an event with all the information about the place, time, etc… and put the materials that came out for the event, which are on the inventory page

how do i do that, can someone help me and indicate

thank you

Would a choice component set to select multiple choices work for this? Point the choice component to your inventory table and save that inventory item ID or Name to the the events table. It will be a comma delimited list of inventory items. Then you can use a Split Text column to split that comma delimited list into an array, and then use that split text array for a relation back to the inventory table.

1 Like