I'm having problems with FM.
I've created all the records I want to import into FM in a exhell spreadsheet, but I've had to merge two different spreadsheets to get all the info in one. I can import the spreadsheet info just fine but I've noticed that one spreadsheet had first name then surname, the other had surname, then first name. So my merged spreadsheet is mixed with the two.
Is there a way for FM to when I navigate through the records in the db I could press a button that record and FM would perform a script that can swap the two around.
I'm almost sure it can I just can't figure it out, any help would be most welcome.