Substitute the data displayed without changing the data. Possible?
I have field Jobs::IsActive where the only two values for IsActive are 0 and 1 (where 0 means the job is archived and 1 means the job is active).
I wish to display this field in a report and give the end user the ability to change the status of a given job.
That is easy but the value I want to display is Archived and Active respectively not 0 and 1.
I tried adding a calculation field referencing the IsActive field and using substitute. That displays the data as I want it but because it's a calculation field the user can't change the field's value.
The table is a shadow table from an external MySQL database not a local Filemaker table.
I feel I should be able to do this as a kind of conditional formatting but can't see how,