0

Invoicenumbers by start

Hello Ninox gurus,
I've been playing in Ninox for a month now and I'm carefully making an app.
In Andy's lessons I learned how to create a specific numbering for the invoice numbers. But someday someone has to start with the database and then just 1 is created.
Have tried several scripts to change that:
let x := 1000
if cnt(invoice number = 1 then invoice number = x
end

But it's not working yet. Does anyone have a solution?
Thank you in advance
Rob

2 replies

null
    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    Single quote around field name that has space and add colon:

    let x := 1000
    if cnt('invoice number' = 1 then 'invoice number' := x
    end

    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    Also, add ending parentheses. I have not tested, but try those changes.

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 523Views