Bill Page

Bill_Page

PAGE

Joined: Sun Jun 07 21:48:38 UTC 2020

My Posts

Latest Posts

Re: Create tables with autonumbering with ease.
Hmm... It sort of works but here are the issues I am left with. See screen shots too. Right click on Customer ID colum header (field) and the above displays.…
- PAGE
- Bill_Page
- 4 yrs ago
- Learn and share
- Reported - view
Re: Leading zero's in a number field
On this note, does anyone know how to add a suffix to the number. I have a number field called Customer ID. In creation, trigger = let t:=this;let maxId := max((select 'Customer Data').…
- PAGE
- Bill_Page
- 4 yrs ago
- Get help
- Reported - view
Re: how to add auto numbering
OK - Changed Customer ID from Text to Number field and now it works. Just have to work out how to add the suffix GP-00 before each number now :)
- PAGE
- Bill_Page
- 4 yrs ago
- Get help
- Reported - view
Re: Create tables with autonumbering with ease.
OK - Changed Customer ID from Text to Number field and now it works. Just have to work out how to add the suffix GP-00 before each number now :)
- PAGE
- Bill_Page
- 4 yrs ago
- Learn and share
- Reported - view
Re: Changing the global unique Ninox ID
OK - Changed Customer ID from Text to Number field and now it works. Just have to work out how to add the suffix GP-00 before each number now :)
- PAGE
- Bill_Page
- 4 yrs ago
- Get help
- Reported - view
Re: Changing the global unique Ninox ID
Hi Guys, I have a similar problem and am getting the results from the following on trigger formula as incrementing by 1 then 11, then 111 etc., so it is just adding a 1 but not adding that number…
- PAGE
- Bill_Page
- 4 yrs ago
- Get help
- Reported - view
Re: how to add auto numbering
See formula on creation of record in table Customer Data (I only have one table for now) 'Customer ID' := max((select 'Customer Data').'Customer ID') + 1 It is incrementing by 10 and not keeping the…
- PAGE
- Bill_Page
- 4 yrs ago
- Get help
- Reported - view
Re: Create tables with autonumbering with ease.
Thanks, however I am getting increments of 10 and the Suffix is lost too :( On Creation I have a trigger: 'Customer ID' := max((select 'Customer Data').…
- PAGE
- Bill_Page
- 4 yrs ago
- Learn and share
- Reported - view
Re: Delete Multiple Records?
That info on changing to Form View mode did the trick - thank you. Still think clicking on the rubbish bin icon should do the same through.
- PAGE
- Bill_Page
- 4 yrs ago
- Get help
- Reported - view
Re: (Newbie) Create New Record from Button Formula Please
Thank you SO MUCH Steve. It works a charm :) (Unlike the Auto Numbering... :( in another thread)
- PAGE
- Bill_Page
- 4 yrs ago
- Get help
- Reported - view
Re: how to add auto numbering
Emphasis, I have tried from information on other threads but still no good as I am getting increments of 10 based on System ID number.
- PAGE
- Bill_Page
- 4 yrs ago
- Get help
- Reported - view
Re: (Newbie) Create New Record from Button Formula Please
Thanks Nick. Unfortunately I get an error and so am stuck. See attached screenshots, while noting that I have one table and it is called 'Customer Data'. Button at the bottom.…
- PAGE
- Bill_Page
- 4 yrs ago
- Get help
- Reported - view
(Newbie) Create New Record from Button Formula Please

The (+) is too difficult to use as low contrast and need to move mouse to top of record to create new record. Therefore, at the end of the record form I have added a big blue button named [Create New…
- PAGE
- Bill_Page
- 4 yrs ago
- 5replies
- 2831
- Get help
Re: Create tables with autonumbering with ease.
Newbie to Ninox so on trial cloud version to try out. Used to be an FMP developer back in the early 2000's and a decade before but gave that up to focus on UX/UI on web-apps so very rusty and a bit…
- PAGE
- Bill_Page
- 4 yrs ago
- Learn and share
- Reported - view
how to add auto numbering

How do I add auto numbering to records on creation please.
- PAGE
- Bill_Page
- 4 yrs ago
- 5replies
- 1474
- Get help

1 2

Welcome to the Ninox community

Bill Page

My Posts

Re: Create tables with autonumbering with ease.

Re: Leading zero's in a number field

Re: how to add auto numbering

Re: Create tables with autonumbering with ease.

Re: Changing the global unique Ninox ID

Re: Changing the global unique Ninox ID

Re: how to add auto numbering

Re: Create tables with autonumbering with ease.

Re: Delete Multiple Records?

Re: (Newbie) Create New Record from Button Formula Please

Re: how to add auto numbering

Re: (Newbie) Create New Record from Button Formula Please

(Newbie) Create New Record from Button Formula Please

Re: Create tables with autonumbering with ease.

how to add auto numbering

Overview