Jump to content
  • 0

Replace field given certain input



1 answer to this question

Recommended Posts

  • 0
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

Link to comment
Share on other sites

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.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...