Hi Everyone!
I have a Business Check module in Zoho Creator. The form has an "Account" selection field, with the following workflow, while record is being created, on success:
- if(Account == "Operating")
- {
- input.Account = "70XXXXXX";
- }
- else
- {
- input.Account = "42XXXXXX";
- }
The code above outputs the correct account number on the Check Record Template. The form also has an Autonumber field for the Check Number, which is also displayed on the Check Record Template.
Question/Problem: Since we are using a single Form to issue checks from two separate accounts, we need the Autonumber field to start at two separate numbers based on the selected "Account". I added a second Autonumber field to the form, disabling one of the Autonumber fields based on the "Account" selected, however, I can't seem to figure out how to "stop" the disabled Autonumber fleid from increasing it's number by 1 upon Form submission. Basically, on each Form submission, one of the Autonumber fields needs to increase in value, and the disabled Autonumber field needs to remain at the same number.
Is there a way to do this, or am I better off making two separate Forms, one Form for one "Account" with one Autonumber field, and a second Form for the second "Account" with the other Autonumber field?
Thank you for any and all assistance in advance!
Adam