Edit Action in Grouped Sequence Incorrectly Adds Row, Causing Duplicate Key Error

[alex_dxw]

Hello AppSheet Team,

I am experiencing a persistent issue with a grouped action that is intended to edit an existing row but is instead trying to add a new row, resulting in a "duplicate key" error.

The Goal: I have a "Re-Engage Applicant" grouped action on my People table. When clicked, it should open a special form (Re-Engage Form), allow the user to input data into two helper columns, and upon saving, update the original People record.

The Problem: When I save the Re-Engage Form, I get the error: "There is already a row with the key: '[key value]'". This shows the app is trying to perform an "Add" operation instead of an "Update".

We have already performed the following troubleshooting steps without success:

1. Verified the Key: The Key column for the People table is PersonID (Type: Text). The specific records we are testing on have valid, non-blank PersonID values.
2. Verified the Action Formula: The action that opens the form uses the correct syntax: LINKTOFORM("Re-Engage Form", "PersonID", [PersonID]).
3. Verified All Names: All table (People) and column (PersonID) names in the formula are correct.
4. Verified Permissions: The People table permissions are set to allow "Updates" for my user role.
5. Checked for Overrides: We confirmed there are no Initial Value formulas in the Re-Engage Form's columns that would override the existing data.
6. Confirmed Default Actions Work: The standard, system-generated "Edit" action for the main People_Form works correctly and opens the form with pre-filled data as expected.
7. Complete Rebuild: We have already completely deleted all actions, views, and helper columns related to this feature, saved the app, and then rebuilt them from scratch with unique names. The issue persists even with a freshly built feature.

The problem seems to be that the context of the record being edited is lost when the LINKTOFORM action is part of a grouped sequence. Could you please investigate why an Update is being incorrectly converted to an Add in this specific scenario?

Please let me know what other information you need.

[Suvrutt_Gurjar · Accepted solution]

Please try an action of 

LINKTOROW(  [PersonID]    , "Re-Engage Form")

However whether it will work or not will depend on how you have configured the group action. If the suggestion does not work, you will need to please furnish more details of the group action, relevant columns and what you are trying to achieve with that group action. 

[alex_dxw]

I've ended up abandoning and simplifying this part of the app, but thank you for your reply.