I have a table of Personas and a table of Gru...

I have a table of Personas and a table of Grupos.

I have an intersection table Grupo Participantes that associates these two; it is a many to many relationship.

A Persona can be a member of 0, 1 or more Grupos, and a Grupo can have 0, 1 or more Personas.

For example, Nick and Jeff can both be participantes in the Tennis and Golf grupos.

I want to define an action to add a Persona to a specific group.

I want to add a row to Grupo Participantes.

On this new row, I want to set the Grupo ID based on a static value or expression.

I want to set the Persona ID to the value of _thisrow for the person that was in context when I click the action.

If I define 3 actions:

Add new row, Set the value of a column (Grupo ID), and Set the value of a column (Persona ID), how do I coordinate the two update column actions to update the row I just created?

I could not find documentation on how to set the values of the columns on the row I am adding.

0 2 331
2 REPLIES 2

tony1
New Member

@Nicholas_Christoffer Right now itโ€™s not possible to create a new row in the background, without the user clicking โ€œsaveโ€. But you can link to a form and set default values. See these example apps: https://www.appsheet.com/Support?q=linktoform&hPP=10&idx=help&p=0&dFR[doc_type][0]=Apps&is_v=1

@tony I wish we could localize the save button for the formsโ€ฆ Then you can change it to โ€œConfirmedโ€ or โ€œReally!!!โ€ (I mean each form sperate)

Top Labels in this Space