FMS11 IIS PHP Publish and automatic date diff calculation if field not null
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