Share
Report
48I am working on an app that I did not create but am trying to decipher. I've found that the app uses Global Variables. Can someone help me understand how this variable is doing what it does? It creates a job number up to 99 when a new job is entered. I've screenshot the app page at the bottom. I need the job numbers to be allowed to go over 99.
Variable: Concatenate(Text(CustNumTemp),"-",Right(Text(Year(Now())),2),varJobNo)
My thoughts on what the variable does:
Concatenate – joins all of the following items into a text field
Text(CustNumTemp – takes the information from the field CustNumTemp and enters it as text
"-" – enters a dash
Right(Text(Year(Now())),2), - pulls the current year and enters it as a two-digit number
varJobNo – enters the job number which is listed in numerical order from 1 to 99
Result:
When a user enters a new job on October 31, 2024 and chooses customer AAA with a customer number of 1000, and it is the 10th job for that customer this year, this variable will produce the following: 1000-24010. The next job entered for this customer would be 1000-24011, and then 1000-24012, etc. Each new customer gets a job number starting at 1 and moving to the maximum of 99, so the first job for customer BBB with a customer number of 1100 would get the job number 1100-24001.
This post is where my questions started. View Column Formulas Previously Created Thanks to all who helped with that one!
Any insight would be very appreciated!
Angi
All responses (
Answers (
