user26705

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!

Outcomes