Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
k.f.kelly
kfkelly
9
0
0
Joined: Mon Nov 12 14:50:21 UTC 2018
Follow
My Posts
Latest Posts
Re: Need a field formula that inserts a unique and sequential number?
Tim, I thought I would report on progress. Giving the problem some thought it seemed odd that the code from the Invoice template was creating a number on creation of the record - before any data was…
k.f.kelly
kfkelly
5 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Maybe I was a bit premature. If I create, say, 10 blank records the serial numbers count up as follows 001,001 then 002 to 010. If I then fill in the invoice information for the 10 records (I delete…
k.f.kelly
kfkelly
5 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Tim, Some progress today. Nothing I tried with the original code made this work so I returned to the Ninox Invoice template as you suggested (as did someone else earlier).…
k.f.kelly
kfkelly
5 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Tim, as I typed in the code let before := max((Table1).Invoice No.);Invoice No. := before + 1 Error returned Field not found: Table1 at line 1, column 25 I tried this with and without (), '',…
k.f.kelly
kfkelly
5 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Tim, I had a couple of hours to play with the database today and as far as I know, followed your instructions exactly. No matter what I tried I experienced the same “Field not found” error.…
k.f.kelly
kfkelly
5 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Tim, thank you. I will follow your procedure and report back how I get on. Maybe in a day or two.
k.f.kelly
kfkelly
5 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
I had looked at that. It made even less sense to me than the instruction provided. I am completely new to this and these instructions are not really designed for someone like me.
k.f.kelly
kfkelly
5 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
I agree that would be the best solution. I followed the instruction, or at least, thought I did but it did not work for me. Clearly, I’m missing something (maybe a lot).…
k.f.kelly
kfkelly
5 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
I want to create a serial number in a very simple database. It is record of invoices received. There are only 5 fields - Serial number, Date of invoice, Amount, Invoice origin,…
k.f.kelly
kfkelly
5 yrs ago
Get help
Reported - view
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics