Add a record from a current database source screen to another database

[Giovanni]

Hello Gliders,

I would like you to ask for help with an app I’m building for a client.

The app is pretty simple.

We have two databases:

• people database
• events database

The client wants to add any person attending the event from the single event page, but I have difficulty finding a solution to add the record to the people database when I’m on the events screen page with the events as the source.

I’ve built a relation between the two databases.

The app is developed on the client account, and I can’t share screenshots of the project with you.

Do you have any tips to make this work?

[Darren_Murphy]

Take a look at the below, I’d imagine it can be applied to your use case.

A NEW way to Trebuchet!

Hey fellow Gliders! If you haven’t heard of the Trebuchet method, it’s a term coined by @Lucas_Pires that refers to creating inline arrays. Inline arrays can be an efficient way to create relations without requiring a helper table thereby preserving your row count! Previously, the Trebuchet method required about 6 columns and 2 custom actions (4 updates to add and remove a single item). This new version of the Trebuchet method cuts that usage IN HALF (3 columns, 1 action). …

[Giovanni]

Thanks Darren, I’ll take a look!

[ThinhDinh]

@Giovanni

The client wants to add any person attending the event from the single event page

I think I have to get this clarified though. Do you mean adding existing people in the people database in a field to confirm they’re attending an event? Or adding new people to the people database?

[Giovanni]

Yeah exactly Thin! Adding existing people in the people database to confirm they’re attending the event and show a list of the people attending the event in the event page.

[ThinhDinh]

Then I think the trebuchet method Darren linked to would help.