I need a script that will edit 1 function from multiple records

[Jesdamian]

Basically there is now a need to take an offline copy of the database to customer's sites.

 

we will be accomplishing this via Mirrorsync.

 

In order to prepare the database i had to add a UUID field that gets generated automatically when a record is modified/created.

 

Its a basic function that converts the date stamp and the record ID into a numeric UUID.

 

This works for data going forward but I have 10,000+ records of data with no UUID.

 

I need to create a way to go through each old record and modify it enough to kick in the auto-generating of the UUID field. 

 

Otherwise I would have to do it manually or Mirrorsync wont run since it doesnt like empty UUIDs in records

[LaRetta]

Go to your field definitions on the UUID.  Change it to type calculation (BACK UP YOUR FILE FIRST).  Enter your calculation and be sure to set it to number result.  And it must be stored so in storage options be sure it is NOT checked 'do not store calculation results'

 

Exit out of field definitions so it populates every record in your table with its results.  Then go back in and change it back to number.  You will notice that your calc remains in the calc dialog.

[Jesdamian]

oh man if this works I owe you a beer. Will try as soon as I get a chance to 

[Jesdamian]

Go to your field definitions on the UUID.  Change it to type calculation (BACK UP YOUR FILE FIRST).  Enter your calculation and be sure to set it to number result.  And it must be stored so in storage options be sure it is NOT checked 'do not store calculation results'

 

Exit out of field definitions so it populates every record in your table with its results.  Then go back in and change it back to number.  You will notice that your calc remains in the calc dialog.

 

 

Im not seeing where I can uncheck "do not store calculation results"

 

FMPro 12

[LaRetta]

When you make it a calculation, lower right says 'storage options'.  In there, be sure 'do not store calculation results' is unchecked.  :-)

[Jesdamian]

ah yes, thank you. it worked perfectly

 

now where do I send the beer?

[LaRetta]

Instead if you wish, you can donate to this forum which provides us all with such a wonderful resource.