AnsweredAssumed Answered

FMS11 IIS PHP Publish and automatic date diff calculation if field not null

Question asked by FlorianWiegand on Mar 4, 2011
Latest reply on Mar 5, 2011 by FlorianWiegand

Title

FMS11 IIS PHP Publish and automatic date diff calculation if field not null

Your post

Dear all,

i am building a database application for my team at work to manage parts of our project more effectively and organize my team. I started to build the application with file maker 11 and then ported it to the fms11 on server 08 r2 with iis.

1. I have two date fields and one field that calculates the working day difference between the two. Eventough i have selected the option to not calculate if fields are empty, it calculates all fields and gives rubbish answeres on data sets which are empty. How can i get fmp11 to check if a field is full, and only then perform a calculation and do this every time i change a view or dataset in the layout?

2. I have a "attachment" field with the field type "container" and a edit box in the layout. I can see the attachments such as pictures in the layout view but if a publish it with the php publisher to the iis, i can see the picture if its present and all others a large rectangle with a red x in it. How can i get rid of the red x and empty box?

Thank you for all your help

Florian

Outcomes