Scripting Field Updates

Discussion created by user26705 on Jun 9, 2016
Latest reply on Jun 9, 2016 by user26705

I am looking to do something similar to the following when the user clicks on a button on the screen:


"Update tblCampaigns Set tblLeads = tblLeads + 1 Where tblCampaigns.CampaignName = tblLeads.CampaignName"


I have tried to do this by using Execute SQL and ExecuteSQL() but have learned that those are not the right approaches or I am not doing it right.  BTW, the tables in the above statement are all FileMaker tables and no ODBC data sources are involved.


This script will also execute other operations and I there is not portal being used or permitted in the UI design.  Any suggestions on how to make this happen - would be greatly appreciated.  I realize I might not be able to use SQL, although would love to, but hoping to learn the best approach for this in FileMaker.


Thank you in advance!