Relationships & Lists

[mowdays]

I have two data types, Account, and Property.
The account data type has fields for users, billing address, company name, phone, etc. The Property data type has fields for the location name, address, services, visit history, notes, etc.

One of the fields in the Account data type is called Property:
Name: Property
Field Type: Property
List checkbox: Checked
My understanding is this field is to list all properties related to the account and create the relationship.

I have the primary field for Property set to “Property ID”.

I have one form to collect information for the new account and the first property. I’m using The Add New Thing workflow when Submit button is clicked.
Step 1: adds a new Property to the Property Data Type.
Step 2: adds a new Account to the Account Data Type.

My problem is I can’t add to the Property list field from the form’s input field that collects the Property ID.
Here is how I have it set up.

Create a new Account…
First Name = Input - First Name’s value
Last Name = Input - Last Name’s value
Property add Input - Property ID’s value
The add input - property id’s value is red and I can’t figure out what to do next.

Any help would be appreciated. Thank you.

[jobs]

Hover over the red text and it should tell you what it is expecting.

My guess is it doesn’t want the id but the property itself, like the result of step 1’s property

[mowdays]

Thank you for the response. I’ve tried using the (add do a search for) and tried different constraints but I can’t get it to work. I see instructions and posts on best practices to have different data types and then create relationships (reference) with other data types, but it’s hard to find help with workflows that actually do this. I can get my results for this field manually by modifying existing entries, I just can’t figure out how to do it in a workflow from a form.

[bubble.trouble]

Hello,

If I understand your question you are looking for a setup like below:

The form creates a new entry in the accounts table with properties chosen from the form. The workflow looks like this:

Bubble provides the tag/list multi select dropdown plugin (image below) that you are seeing used in the image above for the Property List input. It is very useful for these kind of scenarios, although there are certainly other input options if you prefer or need a different style.

You can view the editor here: Double-trouble-bubble | Bubble Editor

[mowdays]

Thanks. It’s actually one form, that adds a new Account and Property without selecting from a list of properties. The account info goes to the Account Data type and the property info goes to the Property Data type, then creates the relationship as the Account as the parent and property as the child.

[bubble.trouble]

Here is that scenario as well, same link as above for the editor:

[mowdays]

THANK YOU! That worked. I was adding more than I needed with the (propertys ID value.