Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
timtaylor.rrfan
timtaylorrrfan
10
0
0
Joined: 12 Nov 2018
Follow
My Posts
Latest Posts
Re: Need a field formula that inserts a unique and sequential number?
Good to know. Thanks for the update. Happy Invoicing. Tim
timtaylor.rrfan
timtaylorrrfan
6 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Hi Kevin, Yes I suppose, however having grown up with computers since they were in rooms the size of my basement and guys with stacks of stiff cards individually punched would load that stack in and…
timtaylor.rrfan
timtaylorrrfan
6 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Nothing I didn't miss more than once. Right after the double parentheses enter the command select with a space between the word select and the word Table. In the name of your field Invoice No.…
timtaylor.rrfan
timtaylorrrfan
6 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Hi Kevin, Would you mind sharing the two code lines you inserted? It may help me see where I erred in my walk through in the above post. Thanks
timtaylor.rrfan
timtaylorrrfan
6 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
My bad on the spelling errors, it is almost 11pm here and waayyy past my bed time. Filed is not filed it should be field. Other missed mistakes on spelling, lack of punctuation, extra words,…
timtaylor.rrfan
timtaylorrrfan
6 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Here we go - Creating a Unique number with or without a prefix such as a specific letter code to indicate perhaps a location, or a numeric code to perhaps indicate a year.…
timtaylor.rrfan
timtaylorrrfan
6 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Got it to work. Thanks Nick. Playing with other features to see what else it will do. Will post full findings and how to in a couple of days. Have to build out a test bed db first.…
timtaylor.rrfan
timtaylorrrfan
6 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Whoops got confused right off. The text typed into the message is different from the text shown in the snip. You have both a text field named Invoice No.…
timtaylor.rrfan
timtaylorrrfan
6 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
Hey thanks that makes it easy. I'll give it a go and let you know how it turns out. Looks like though that the field it will reside in has to be a text field?…
timtaylor.rrfan
timtaylorrrfan
6 yrs ago
Get help
Reported - view
Re: Need a field formula that inserts a unique and sequential number?
I think I am missing something that was probably shared in the 1 to 1 that I am not pulling out of the help message. I am also trying to figure out what is meant by the answer.…
timtaylor.rrfan
timtaylorrrfan
6 yrs ago
Get help
Reported - view
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics