Jump to content
  • 0

Adding a Prefix with Calculated Value



I'm trying to get the value from an existing Autonumber from one table and add a prefix to it for another field, Quote Number, in a different table. 

The existing Autonumber is called AutoBidID and comes from the BidTable. In the new submission form for the new table, this AutoBidID is getting captured by a cascading autocomplete Virtual Field that works once a Job Name is selected from the dropdown. Job Name gets its values from the BidTable.

So, now I have the AutoBidID for the job I am creating a form for. I am simply trying to add a '2-' to the beginning of this number. In example, if the AutoBidID for the Job I select is 3002, the new Quote Number would be 2-3002. If the AutoBidID was 1234, the Quote Number would become 2-1234. 

Quote Number is a calculated field. This is how I'm trying to add the '2-'.  I have tried the following:

2- + [@cbParamVirtual51]

"2-" + [@cbParamVirtual51]

Stuff('2-', [@cbParamVirtual51])    -also tried without the quotes.

Stuff([@cbParamVirtual51], 0, 0, '2-')


Any help is appreciated. The AutoBidID is a Autonumber type. The Quote Number is a text field. Just trying to 'copy' the numbers and add to them.


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.

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...