How do I fetch data from two forms into a third form?
I'm new to creator and am setting up forms for a seed bank. I have three forms:Collection, Storage, and Withdraws.
On the Withdraws form I want to fetch data from both Collection and Storage forms based on the user input in a lookupfield with unique values (this field is on all three forms).
I set up the Storage form to fetch specific fields from the Collection form, and thought I could just daisy chain and fetch all the necessary fields for the Withdraws form from the Storage form, but it doesn't seem to be possible to fetch data that was fetched from another form.
I want the Withdraws form to show collection site, collection date, collector name + storage date, storage quantity, storage location.
Does anyone have a work around or alternate solution?