I was creating a database with names and addresses and I forgot to add an entry. How do I go back and place it in the spot it was supposed to be in the list?
the "spot it was supposed to be" is a misconception, solved by sorting.
Think about a new medical practice, which has 0 patients the first day and gets new patients by the hour, each having first and last names which do not get at the right place, they just get appended to the patient table, but with a sort by surname, firstname you get what you want.
You can give them a key with Get(UUID) and at 2 AM run a script that finds all, sorts and does a replace with serial on a NumID, but what is that good for ? During the day the NumID won't be of great use.
Remember: bad info is worse than no info.
The database is not sorted. I am doing a list for someone’s wedding and she wants it in the same order that she gave it to me.Once I omitted a name, I can’t go back and put it in the correct spot it was on her list. That is my issue.
Then you need to add a field for rowNumber and fill it in and sort by this.
If you omit one record from a found set, you can't un-omit it. You just use the original find again.
thank you. i will try that
Sent from my iPad
Type Command+ J or select Show All from the Records Menu or put show all in your script...
Omitting does not delete the record, it just hides it.
Use the idea above for adding a sort field. Increment on creation by 10 (small list). This lets you insert in between if you don't like numbers.
Show your client this wonderful idea and tell her she can change the sort order at any time for whatever reason. Client's do change their minds or discover that someone more important shows up and needs to be higher on the list.
Sort the records the way you want them to appear. Export the records. Delete the records and then import the records from the export file. The records will now default in the order you want.
Retrieving data ...