Duplicate table entries

plazatm · 2020-10-16T20:21:57.130Z

Any advice would be very appreciated! My simple form is working but it is duplicating entries, not adding the list to Account-Venues.

I have 2 tables.
Accounts
Venues

Accounts is linked to Venues

I have this simple search function to find a venue and add that venue to the current page’s account.

Here is my workflow.

image572×517 18.7 KB

It’s doing what I want except that instead of adding the venue to the Accounts, Accounts-Venues list it’s creating a separate Account entry.

image1485×85 7.19 KB

Thanks!

mikeloc · 2020-10-16T22:10:56.486Z

Hi there, @plazatm… it’s creating a separate thing in the Accounts data type every time because that is exactly what your workflow is telling it to do. Instead of using the action that creates a new thing, you want to use the action that makes changes to a thing. The thing to change is the current page’s account, and the change is to add the selected venue to the account’s list of venues. Does that make sense?

Hope it helps.

Best…
Mike

plazatm · 2020-10-16T23:57:14.061Z

Hi, thanks for the help!

I have tried making a change to the list but I can’t figure out what the correct formula would be. Here’s what I’ve been trying. I’ve been trying to figure it out but everything I think should work is red.

image1777×1090 90.7 KB

mikeloc · 2020-10-17T00:19:46.243Z

Hmm, you used the Make changes to a list of things workflow action, but you need to use the Make changes to thing action. When you use that action, you should be able to select the current page’s account as the thing to change, and then you can add the value of the venue input to the account’s list of venues.

If you can’t get it to work and you are willing to share a link to your editor, I would be happy to try to set it up for you.

Best…
Mike