Two questions
Ninox Profile

Hi;

I have a problem with my customer number

I would like the customer number to start automatically from 1000 

For exampe first customer 1000 and second customer 1001 and

Third customer 1003  I need formula it and say me where do i write this formula.

 

second question:

About field of invoice number: i have in table invoice one number field that i write some number there. I will invoice number be include: First name + last name+ number field (I want only the first letter of the name and the family)

for example: first name is: saeed    Last name is: rahimi   And my field number is: 23454   Result want be: SR23454

thank you

 

 

 

 

Ninox Profile

For the name parsing.. See the following
https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language

then serach for substr .. substr(string, start, length) – Extracts a part of the string. Start is zero-based.

For the number.. hmm.. perhaps a Trigger on Create ... max(select Customer.Number) ... check if null .. then first customer so set to 1000.. else add +1 to the number and set the current one. 

 

Ninox Profile

Unfortunately I could not do it

Ninox Profile

Hi,

Please book a call with us, so that we can help you,  https://ninoxdb.de/en/support

Regards, 

Sakshi-Ninox

Ninox Profile

thank you Sakshi

I was able to do it.  

 

Reply