AnsweredAssumed Answered

Substitute the data displayed without changing the data. Possible?

Question asked by dinoapolito on May 2, 2015
Latest reply on May 2, 2015 by philmodjunk

Title

Substitute the data displayed without changing the data. Possible?

Post

Hi,

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,

Many thanks

Dino

 

Outcomes