Replace value in a field - in script
I am looking for the script step to use to change 0 to No, and 1 to Yes in a field in all records.
This may take 2 steps which is OK.
I tried Perform Find/Replace, Set Field by Name, Replace field contents: not quite sure how to use them.
Also do I do record movement myself or is there a blanket find/replace that would do it for the found set?
And the question is necessary because Filemaker dos not have a Boolean data type so I assume I need a Yes-No value list for these fields...correct?
Thanks! Haven't used Filemaker in a number of years...