Trouble figuring out calculation

[eddiedredge]

Hi All, 

 

I'm using FMStarting Point and I'm looking to grey out a box in and read "absent" in the box on a report I have made on a given date and subject populated from the "Communication and Notes" section of a contact. 

 

For example if the if the subject in the "Communication and Notes" is selected as "absent" and the date is 23/07/2014 then I need the box on the report to read "absent" and be greyed out that day. But because I print the report maybe 5 days in advance I need the calculation to wok if its printed within five days of the date and including the date before the actual day. 

 

I hope that all makes sense. If anyone is able to help and is able to offer an explanation to the calculation that would be so great. I'm keen to learn from all the help and understand how the calculation was reached

 

Many thanks in advance. 

 

Eddie

[Nuos]

Hey Eddie

 

You don't need to use a calculation. On the layout, right click the field and select Conditional Formatting.  Play around in there.  I'm pretty sure you can set fill colour.  If not you can try creating a square and fill it in with grey.  In inspector under data set box to hide "Communication and Notes" <> (means not equal) "absent".  To associate this to a date as well I would need to know how the date is associated to the "Communication and Notes" table.  If the C&N record is displayed through a portal, can you associate this portable table with the date in some way.  If not you could always add this to the hide equation (i.e. "Communication and Notes" <> "absent" AND layouttabel::date=associatedTable::date

 

Set it behind the field and set field to no fill.  

[eddiedredge]

Hey Eddie

 

You don't need to use a calculation. On the layout, right click the field and select Conditional Formatting.  Play around in there.  I'm pretty sure you can set fill colour.  If not you can try creating a square and fill it in with grey.  In inspector under data set box to hide "Communication and Notes" <> (means not equal) "absent".  To associate this to a date as well I would need to know how the date is associated to the "Communication and Notes" table.  If the C&N record is displayed through a portal, can you associate this portable table with the date in some way.  If not you could always add this to the hide equation (i.e. "Communication and Notes" <> "absent" AND layouttabel::date=associatedTable::date

 

Set it behind the field and set field to no fill.  

 

Hi Marcus, 

 

This is great. However I cannot get the date field calculate. As soon as I add anything to do with date it greys out all records in the found set. 

 

Any advice would be greatly appreciate

 

Many thanks

[Nuos]

Can you show me some screen shots?  I think I may need to be clear on the context and what you are trying to resolve.

[eddiedredge]

Can you show me some screen shots?  I think I may need to be clear on the context and what you are trying to resolve.

 

Hi Nuos, 

 

Apologies for the delay I have attached the relevant screen shots. I forgot to mention that I may print the register up to 6 days before the date the register is needed meaning the calculation needs to take this into account. Many thanks for all your help