Hi everyone,
I have something that worked for over a year and now it's broken and I can't figure out why. I have a Main Custom list that has a data connection data from another list GateList (GateName, SeedGateNumber)
When the user created a record in the Main list and selected a gate name then I get the max SeedGateNumber and increment that by one and assign that number to the one of the fields in the Main list. At the same time I also update the SeedGateNumber in the GateList with the new number. It is basically a unique sequential record id increment for each of the record in the Main list.
The trigger for the update of the SeedGateNumber in the Gatelist is done via a button Rule. Run Actions: set a field's value from myDataConnection\myFields\dataFields\SeedGateNumber field name with the value of the incremented value.
Data Connection is set to receive data. Greatly appreciated if anyone can help me troubleshoot this.
Steve