0

Two questions

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

4 replies

null
    • Mconneen
    • 5 yrs ago
    • Reported - view

    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. 

    • New_Sun
    • 5 yrs ago
    • Reported - view

    Unfortunately I could not do it

    • Sakshi_Singh
    • 5 yrs ago
    • Reported - view

    Hi,

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

    Regards, 

    Sakshi-Ninox

    • New_Sun
    • 5 yrs ago
    • Reported - view

    thank you Sakshi

    I was able to do it.  

Login to reply

Content aside

  • 5 yrs agoLast active
  • 4Replies
  • 1597Views