AnsweredAssumed Answered

Can numbers be changed automatically

Question asked by Pondwater on Jun 19, 2010
Latest reply on Oct 29, 2014 by KellyFisher

Title

Can numbers be changed automatically

Post

Is there a script that can be written the change the individual numbers in a field? I am contemplating a database that has a unique priority number for each entry. Say, one record has a priority number of 18 (there would never be more than 25 records), and suddenly it should be moved to #1. Is there any way to make it #1, change the prior #1 to 2 and so on down the numerical line? Or is #18 jumped to #5 could the first 4 stay the same and the others moved down to the point where #17 became the new #18.

 

If this is possible it would be done on FileMaker 11 and accessed by both Mac and PC

Outcomes