Forums

I am trying to update a field in a record in a table based on one of the fields in the form. I have changed the "write action" to Update but when I add the update condition nothing is written to the table/field. If I leave the update condition blank, the field I want to update gets updated for ALL records in the table (definitely not what I want). I am thinking my syntax is wrong. Can someone please look at it and let me know.

[file=10008]Field-Seed.jpg[/file]
[file=10009]Field-Team_id.jpg[/file]
[file=10010]Save_Action.jpg[/file]
[file=10011]write-debug.jpg[/file]

Hi vividal,
{Teams.team_id} has no value, you have a field named team_id and so you may want to use {data:team_id} to reference the value of that field!
Best regards

I just tried TDT.team_id:{data.team_id} as an Update Condition and that doesnt change the record either. any other thoughts?

Hi vividal,
A debugger after the "Save data" should show you the SQL command executed, you can then change it accordingly, or post it here.
Best regards

Hi vividal,
A debugger after the "Save data" should show you the SQL command executed, you can then change it accordingly, or post it here.
Best regards

Hi vividal,
A debugger after the "Save data" should show you the SQL command executed, you can then change it accordingly, or post it here.
Best regards