Forum Discussion

JessicaFeauto2's avatar
JessicaFeauto2
Qrew Cadet
7 years ago

Actions ""Add New Record"" to table with same Key field

I've been using Actions for a while.  I have observed is that if I choose the "Perform Action Type: Add New" and the value am inputting into the Key Field of the table where the new record is created ...
JessicaFeauto2's avatar
JessicaFeauto2
Qrew Cadet
7 years ago
You missed my point.  in the event that I do include the Record ID for Add Record, if the Record ID already exists, it just modifies the existing record.  I want someone to confirm that it works this way.

I don't want to have to use "Edit Record" for an Action because the data is coming from Synced table and I don't want to change the Key field of the synced table.
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    7 years ago

    Is the synced table related to the table the Action is pointing to? If so, you can provide the Related Record ID#.

    Anytime you input to Record ID#, you're updating if the value you're providing exits.

    As you may not have two identical Record ID#s in the same table, the behavior you're experiencing is valid and correct. If you should provide a value to Record ID# and that particular Record ID# does not already exist, the system will issue you an error, which is valid and correct.