Scott Posted November 2, 2017 Report Share Posted November 2, 2017 I have a field in a dataform. [@field:Rego] If a person enters "UNREG" into this filed I would like the field to populate with the [@field:AutoNumber] field on hitting the submission button. Any ideas??? Quote Link to comment Share on other sites More sharing options...
0 Mathilda Posted November 7, 2017 Report Share Posted November 7, 2017 On 11/2/2017 at 5:43 AM, Scott said: I have a field in a dataform. [@field:Rego] If a person enters "UNREG" into this filed I would like the field to populate with the [@field:AutoNumber] field on hitting the submission button. Any ideas??? autonumber field will be populated for every records, therefore you would need to use integer field instead. If triggers available for your plan, you can do that using triggered actions, if no - you could use java script. In case of creating java script function I would add a virtual field (drop-down, displaying values, gotten from the table in descending order - this will give you the most recent value) and incrementing a value if value in rego field = unreg You may find an example here Quote Link to comment Share on other sites More sharing options...
Question
Scott
I have a field in a dataform. [@field:Rego]
If a person enters "UNREG" into this filed I would like the field to populate with the [@field:AutoNumber] field on hitting the submission button.
Any ideas???
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.