I’m trying to link data between two Types of Things.
My app is for a photographer. I have a “create new photo shoot” form. On that form I would like to give the photographer the ability to create a new client OR select from a list of existing clients.
So I created one Type of Thing called CLIENTS with these Text fields:
- Client First Name (text)
- Client Last Name (text)
- Client Email (text)
I have another Type of Thing called SHOOTS with those same fields except I’ve set them to type Clients:
- Client First Name (clients)
- Client Last Name (clients)
- Client Email (clients)
So how do I link those two types of things? My “create new photo shoot form” workflow will successfully add a new client to the CLIENTS table, but it will not add that same client to the SHOOTS table.
It’s important for this data to be linked so that if the photographer edits the name or email of a client, that information will update on all of the photo shoot records for that client.
This is my current workflow in photos.
Step 1: I create the new shoot - this works right now. This data all goes to the SHOOTS table.
Step 2: I create a new client - this works as well. This data is added to the CLIENTS table.
Step 3: I’m trying to say “change this shoot’s client’s name to the client name that was just added to the Clients table in step 2.” I can’t figure out how to do that.
Any help is greatly appreciated!!