Im little bit confuse how the invoice number works what i want is if i click the generate invoice it generates an invoice# but when i create a new record the invoice# should be empty

Are you using the Auto Enter?

No What i want is if i click this button it generates a invoice #

Read about the Auto Enter Serial Number function.

 

Open up the "Invoice" example file that came with your FileMaker App.

 

Create a company

Create a few customers

Create a few products

Create a new invoice. 

 

Tear these files apart and you will see how the Invoice ID number is created in the Manage Database, see the options for the field Invoice ID.

I'm still confused how its done this is the screenshot what i want is if i click the generate invoice button it must generate a invoice number also can you provide a sample data so i can study how its done thanks.

 

https://www.dropbox.com/s/jwy3vcslod6r3mu/Invoice.png

Attach your file here.

Hello Lee I cant attach the file here because the file is in the third party server what i want only is a example how the process work

when i click the button it generates a invoice number

 the file is in the third party server what i want only is a example how the process work

when i click the button it generates a invoice number

 

The File is hosted? Is this your file? Did you look at the button in the Invoice file?

This is our file actually the invoice task is assigned to me i need a simple script how to generate invoice number 

examp if i click that generate invoice a number should be INV1000 if i click it again it should be INV1001

Why do they need to be sequential? Surely so long as they are unique, that will be fine?? We use a UUID generation for invoice numbers - especially if they are not created upon record creation...