Dear Community
We are trying to update a Row in Confirmation Table (Tab) via another TAsk Tab via a Form.
When click on Create Application Invoice, destination is Confirmation
We have also Custom Action
We are not sure why the intended data is not updated to the right row, but created in as another row in Confirmation!
We have managed to perform the required 1 day back. But when we added another Create button, this does not work any more.
Any advise is much appreciated!
Have you tried changing that to use a different Destination Table/Sheet?
@Darren_Murphy Hi Darren, changing back the main tab i.e. Tasks should be able to work, but will need all the required fields into Task Table.
However the logic that we have set up should work, and we are still trying to figure out how Glide treat such flow and the limitation.
The main point is why a new row is created when we didnât indicate so.
Does it have to the with the form we have use i.e Show New Form, Show Edit Form etc. ?
We have used Show Form and Show Edit Form to try to get the effect
Show form gives an extra row.
Show Edit form cannot be used, because once we wanted to set up the components, it affect the destination tab Edit form
The whole of this will be affected
The Form screenâs sole purpose is to add rows. As soon as you click on the submit button, it adds the row. Thatâs what itâs designed to do. A Form screen is not meant to edit an existing row.
You may need to use something like âShow New Screenâ and create a custom edit screen to update an existing row.
Got it! Let me try!
New screen cannot have special components to update certain fields by default though.
What about Edit Screen? Can we have different Edit screen when required?
You canât have different Edit Screens. You an only have one Edit screen and itâs permanently linked to the table.
A custom action could write special values to certain columns before opening the new screen. Or you could set up your custom edit screen so you fill user specific columns, and then add a button that writes those users specific values and special values to the existing row.
Thanks for your reply.
Let us check and work on it.
Hi hi
Realised that when i use a show New Screen to create the form, when values are keyed into the form,
The âbufferâ values are updated on first row, causing the first row data to be incorrect.
Yes, thatâs expected behaviour.
If you want to use Show New Screen, then the target (Data) needs to be âThis Itemâ.
Thanks
This Item refers to the current Row ID in this Tab / Table?
Kindly advise where can i read up on this This Item, References etc?
Yes, thatâs correct.
I donât know that there is any specific documentation on âThis Itemâ, but what you are doing there is essentially creating whatâs commonly referred to as a Custom Form. To learn more about that, you can make a copy of the concept app in the below thread and study it.
Even though there is only one edit screen, you can set visibility conditions to the edit screen components to have one set show under one circumstance, and another set show under another circumstance. This wonât always be the best solution, but it works great in some cases.
