Forum Discussion

BarryGulino's avatar
BarryGulino
Qrew Cadet
9 years ago

Number Format of Field not transferring to exact form.

The auto-generated File Number - [Record ID#]+150000, in the database is formatted as formula numerical with no decimal places and no commas. Example 123456. When I insert the field in an exact form, ...
BarryGulino's avatar
BarryGulino
Qrew Cadet
9 years ago
This is a field that automatically assigns each file a file number starting at 150000.  [Record ID#]+150000.  I don't think a formula text field will accomplish what we are trying to do.  The first file opened is 150001 then 150002, etc.  Doesn't this have to be a number?  Like I said before, I tried ToText([Record ID#]+150000) and that didn't work.