Text based on field value

[customfamily]

Hey all,

So what I'd like to achieve is have different text to appear based on what is in a certain field.

More specifically, I have a data entry page where you can select from a checkbox whether a location has been scouted (yes / no). On a summary overview page I'd like text to appear that indicated the status of the location and if it has been scouted (value: yes) I'd want it to say "Location was scouted" but if it has not (value: no) then it would say "Location has not been scouted".

In addition to this, I'm hoping to add the scout date to the first caluclation from a separate field (Scout Date field). So the if the location has been scouted it would say: Location was scouted in 2009.

I'm sure its pretty simple but I can't seem to find the right calculation for this. I'm pretty new to FM.

Thanks so much. Yeah, this is not what we should be doing on the 4th of July weekend :

Regards,

Rob

[Anuviel]

I would try and IF or a Case statement, maybe something like

IF (Location = "Yes" ; "Location was scouted" & Date ; "Location has not been scouted" )

[Lee Smith]

Here is the Case, and I believe you need the Year Function?

Case (Checkbox = "Yes"; "Location was scouted" & [color:blue]Year ( Scout Date) ; "Location has not been scouted")

Lee

[comment]

I don't see why you need the checkbox - if there's a date in the Scout Date field, then clearly the location has been scouted.

Do you have locations scouted on an unknown date?

[customfamily]

Thanks so much guys, this is much simpler than I expected. I had been trying to specify value lists to use in calculations...this worked perfect.

Thanks so much. With this behind us I suggest we all head outdoors for the weekend.

Regards,

Rob

[customfamily]

Yes, the majority have no specific dates. But I understand your logic.