Jump to content

How to search for last number in a field?


This topic is 5645 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi all,

Each one of my Records has a Contract layout but not every record has a contract. When I come to draw up a new contract I would like to find the last contract number in the field using a button on the Contract layout.

Any ideas?

Link to comment
Share on other sites

I do hardly suggest anyone to utilize copy/paste, and in particular now when GeNthRecord( esists.

I know I was a little snotty in my previous reply, because what if not relations exists. What you can do is to make a valuelist based upon the contractnumber, the issue you probably here raises, is that autoentering isn't strictly fitting into your business model which could be "Give the emperor what is the emperor's and give God-what is God's." kind of bookkeeping :P

Set Field [ Untitled::contractNumber; GetAsNumber ( RightWords ( ValueListItems ( Get ( FileName ) ; "theNumbers" ) ; 1 ) )+1 ]

What it does is to sort the numbers prefereably with leading zeros via a valuelist, causing the latest entry to latest in the valuelist, convert the list which is in textformat back into numerical and add one to it.

--sd

Link to comment
Share on other sites

This topic is 5645 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.