Newbie Autonumbering Fields after sort. - comp.databases.filemaker

Hello, I have a simple table that displays an Item Number (one item per record) I also have a Date and a Time field. I want to create a script that sorts the table by Date and Time, and then to automatically renumber the Item Numbers based on this chronological sort. I may also want to add (+) a value stored on a separate table to this series. For example, on a separate table I have "Previous Number of Items" amount ( a single number). Lets say the number is 120. After the sort, I want the first record to be 121, then 122 and so on. Also, I want to store on the separate table, the total number of records in the Item table + the "Previous No. of Items". So basically, what script do I use to count the total number of records in a given table. Many thanks for all the help!!

Nando wrote: >Hello, > >I have a simple table that displays an Item Number (one item per >record) I also have a Date and a Time field. I want to create a script >that sorts the table by Date and Time, and then to automatically >renumber the Item Numbers based on this chronological sort. I may also >want to add (+) a value stored on a separate table to this series. > >For example, on a separate table I have "Previous Number of Items" >amount ( a single number). Lets say the number is 120. After the sort, >I want the first record to be 121, then 122 and so on. > >Also, I want to store on the separate table, the total number of >records in the Item table + the "Previous No. of Items". So basically, >what script do I use to count the total number of records in a given >table. > >Many thanks for all the help!! Look at the Replace Field Contents script step. Matt

Nando wrote: >Hello, > >I have a simple table that displays an Item Number (one item per >record) I also have a Date and a Time field. I want to create a script >that sorts the table by Date and Time, and then to automatically >renumber the Item Numbers based on this chronological sort. I may also >want to add (+) a value stored on a separate table to this series. > >For example, on a separate table I have "Previous Number of Items" >amount ( a single number). Lets say the number is 120. After the sort, >I want the first record to be 121, then 122 and so on. > >Also, I want to store on the separate table, the total number of >records in the Item table + the "Previous No. of Items". So basically, >what script do I use to count the total number of records in a given >table. > >Many thanks for all the help!! Answer to the second question: Create a calc field using the Count function. Matt

Thank you Matt, but I think this will only replace the field only in the current record. I need the script to cycle thru all the records after the chronological sort. Thanks again, Nando On Mon, 15 Aug 2005 09:17:31 GMT, "Matt Wills" <I'm@Witz.end> wrote: >Nando wrote: > >>Hello, >> >>I have a simple table that displays an Item Number (one item per >>record) I also have a Date and a Time field. I want to create a script >>that sorts the table by Date and Time, and then to automatically >>renumber the Item Numbers based on this chronological sort. I may also >>want to add (+) a value stored on a separate table to this series. >> >>For example, on a separate table I have "Previous Number of Items" >>amount ( a single number). Lets say the number is 120. After the sort, >>I want the first record to be 121, then 122 and so on. >> >>Also, I want to store on the separate table, the total number of >>records in the Item table + the "Previous No. of Items". So basically, >>what script do I use to count the total number of records in a given >>table. >> >>Many thanks for all the help!! > >Look at the Replace Field Contents script step. > >Matt

That's what the 'Replace' function is there for. You should read the Help. Remi-Noel "Quite Curious" <not@home.com> a �crit dans le message de news: 78g1g15jmifna78680u57lono8sqbhkp2h@4ax.com... > Thank you Matt, but I think this will only replace the field only in > the current record. I need the script to cycle thru all the records > after the chronological sort. > > Thanks again, > Nando > > > > > On Mon, 15 Aug 2005 09:17:31 GMT, "Matt Wills" <I'm@Witz.end> wrote: > >>Nando wrote: >> >>>Hello, >>> >>>I have a simple table that displays an Item Number (one item per >>>record) I also have a Date and a Time field. I want to create a >>>script >>>that sorts the table by Date and Time, and then to automatically >>>renumber the Item Numbers based on this chronological sort. I may >>>also >>>want to add (+) a value stored on a separate table to this series. >>> >>>For example, on a separate table I have "Previous Number of Items" >>>amount ( a single number). Lets say the number is 120. After the >>>sort, >>>I want the first record to be 121, then 122 and so on. >>> >>>Also, I want to store on the separate table, the total number of >>>records in the Item table + the "Previous No. of Items". So >>>basically, >>>what script do I use to count the total number of records in a given >>>table. >>> >>>Many thanks for all the help!! >> >>Look at the Replace Field Contents script step. >> >>Matt >

Replace Field Contents performs the replacement on the specified field in all records in the found set. In fact, FM Help specifically mentions what you want to do as one of the possible uses for the step: "This step can also be used to reserialize a field in every record in the current found set." Matt Quite Curious wrote: >Thank you Matt, but I think this will only replace the field only in >the current record. I need the script to cycle thru all the records >after the chronological sort. > >Thanks again, >Nando > > > > >On Mon, 15 Aug 2005 09:17:31 GMT, "Matt Wills" <I'm@Witz.end> wrote: > >>Nando wrote: >> >>>Hello, >>> >>>I have a simple table that displays an Item Number (one item per >>>record) I also have a Date and a Time field. I want to create a script >>>that sorts the table by Date and Time, and then to automatically >>>renumber the Item Numbers based on this chronological sort. I may also >>>want to add (+) a value stored on a separate table to this series. >>> >>>For example, on a separate table I have "Previous Number of Items" >>>amount ( a single number). Lets say the number is 120. After the sort, >>>I want the first record to be 121, then 122 and so on. >>> >>>Also, I want to store on the separate table, the total number of >>>records in the Item table + the "Previous No. of Items". So basically, >>>what script do I use to count the total number of records in a given >>>table. >>> >>>Many thanks for all the help!! >> >>Look at the Replace Field Contents script step. >> >>Matt

Similiar Articles:

Summarize a field - comp.databases.filemaker
Newbie Autonumbering Fields after sort. - comp.databases.filemaker ... Summarize a field - comp.databases.filemaker... global variable with the sum of the values of a ...

Lookup: Howto display one field and store the value of another ...
Newbie Autonumbering Fields after sort. - comp.databases.filemaker ... Lookup: Howto display one field and store the value of another ... Hi I am a filemaker newbie ...

[newbie] Adding and configuring new disk - comp.sys.hp.hpux ...
Newbie Autonumbering Fields after sort. - comp.databases.filemaker ... I may also want to add (+) a value stored ... Cisco IOS configure router for DHCP VIA CLI - newbie ...

Concatenate text from related records? - comp.databases.filemaker ...
... making relationships, layouts, showing related fields ... FIRST related record ("first" depends on the sort ... Auto numbering related records - comp.databases.filemaker ...

replicating MS Excel percentrank formula - comp.soft-sys.matlab ...
Then do this: [x,p] = sort(data); % Put data in ... must be a better way in matlab but I am > % a newbie ... between, so have to write re ... order of second field ...

Tried F1, Google, my var etc..... :-P - comp.cad.solidworks ...
Are the property fields named the same in the old Drawing ... Pete Newbie wrote: > Ok, this is what I want to do ... to improve the portability of Sage http ... some sort ...

Creating a unique alpha number serial ID - comp.databases ...
Second, add leading zeros which would help me sort by the ID field. But this scenario ... Auto numbering related records - comp.databases.filemaker ... Creating a unique ...

Syntax error trying to return scalar value from query in stored ...
I am (a newbie) having trouble creating a stored function ... set with only one row and in that row only one field ... be faster, is it due to context switching or some sort ...

how to duplicate rows - comp.soft-sys.sas
I have a table with the following fields Date ... or shape but two columns in both contain the same sort ... This is something of a newbie question.. I'm working with ...

image processing - comp.soft-sys.matlab
(0 or 255) After you find a B/W value you will look ... are right it is black and white dots but I am a newbie ... As a subcategory or field of digital signal processing ...

Fields that generate numbers automatically in Access - Access ...
Applies to Microsoft Access 2000 and 97 In an Access database, you can create a field that automatically generates a unique number when you enter a new record in a table.

7/17/2012 9:30:08 PM