Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

k.f.kelly

kfkelly

9
0
0

Joined: Mon Nov 12 14:50:21 UTC 2018

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…
- kfkelly
- 6 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…
- kfkelly
- 6 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).…
- kfkelly
- 6 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 (), '',…
- kfkelly
- 6 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.…
- kfkelly
- 6 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.
- kfkelly
- 6 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.
- kfkelly
- 6 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).…
- kfkelly
- 6 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,…
- kfkelly
- 6 yrs ago
- Get help
- Reported - view

Back to top

Overview

View all topics