Data: Edit a row of another table using the values from this row

Hi!

I would like to request the addition of the feature:

Data: Edit a row of another table using the values from this row

You can accomplish this with two actions:

  1. a data set action to set the column values you want
  2. a navigation action to open the form you want (after the edits)
2 Likes

@MultiTech_Visions

Hi! Thanks you for the suggestion, but doing so ( 1. a data set action to set the column values you want)
would require me to create a connection between source row and target table. Creating connections between table is not really applicable to every app.

I am thinking of a situation where the user will browse the current table and select a specific detail row. An action would be available that will let me edit a specific row of another table using the current table’s details.

In generally you could do this with a combination of LINKTOROW and “Reset initial value”.

1 Like

@Aleksi
Might work on some apps but the same with previous suggestion, Toggling “Reset Initial Value” ‘on’ and setting a formula in “Initial Value” would require me to establish a connection between Table 1 & Table 2. Naturally, with this method I would need to set a formula to “Initial Value” option, like LOOKUP or such, to arrive into the value I desire, but I cannot think of a way to really “Get the value of the current table’s selected row using a formula.” One way I can think of is using LOOKUP but I cannot think of a way to lookup to the content of the current selected row.

Because you can’t read the record where you are coming from with the LINKTOROW, you should mark it before leaving it… like with an action and value NOW(). Then you can read values from the latest record from that source table.

1 Like

@Aleksi

The app is actually used by multiple users. Leaving a mark to the row might leave some problems when users execute the same action on different rows all at the same time. LOOKUP will surely detect only the top row which has a mark. They will all use the value of the same top row as source values

You could use USEREMAIL()&NOW.

1 Like

Good solution. However, I would like to limit writing data to tables as much as possible because this is a field service app. Signal may not be good at specific areas, so syncing is recommended to be less. For now, I could use your solution. Thanks @Aleksi

I would like to please request this as an explicit feature that allows one to ‘edit a row to another table using values from this row’.

It would be something like a variation on the action: “Data: add a new row to another table using values from this row”. It seems the groundwork for such a feature already exists.

This will be more simple and direct and avoid the compromises and improvisations suggested previously.

1 Like