Jump to content

Create an Automated Script to Increment a number by 1


This topic is 1295 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am a beginner in Filemaker using Filemaker 18 and I need a script to increment a number by 1.

I have 3 fields.

Start Number

End Number

New Number

I want to enter a number in the start field "50"

I want to enter a number in the end field "100"

I need the script to create a new record each time filling in the "New Number" field starting at 50 and ending with 100

Please dumb down the answer as much as possible because I am not at all familiar with scripting.

Capture.JPG.c165ac2259843a021e4f771be41bdcab.JPG

Thanks in advance for the help

 

 

Link to comment
Share on other sites

Can you explain why you need this? It seems like you should have two tables: a parent table where you would enter the start and end values; and a child table where the script would create an individual record for each value between start and end, and relate it to the parent record. Having all three fields in the same table makes very little sense.

 

Link to comment
Share on other sites

Thank you for your help. It looks like it will work. One other question. In filemaker after data is entered is there a way to lock the data so it cant be modified by the user.

For example the data entry department enters the data

But you don't want the sales staff to be able to alter what they entered

Link to comment
Share on other sites

 I am back to the barcode database question.

I added a field called "Barcode" and a field called "Barcode Calculation"

I need the value that you are creating in the child table record to go into the barcode field so that I can change the Barcode Calculation field to a Barcode font.

 

Right now it is showing up as a 0

I have attached the DB you sent me with my additions. can you tell me what I have to fix to make this work.

 

GenerateSeries.fmp12

Link to comment
Share on other sites

This topic is 1295 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.