Haven't been able to figure this one out yet...using FM Pro 4.

I have a portal showing several records with several fields for each record. Some of the fields need to remain empty until an action occurs. The data in the portal rows/records line up as long as each field in each portal record contains data. However, if a portal record has an empty field, that field for the remaining portal records shifts up.

In FMP this is no problem.

I have tried using an [FMP-if] command to input an "N/A" if the field is blank but so far that hasn't worked.

Any ideas would be appreciated.

JM

------------------

Use an [FMP-If] statement within the protal to check whether the field is empty or not. If it is empty, insert a non-breaking space and/or a <p> tag to fill-out the table row.

I just read you tried somethig similar... no problem, do it at the FMP database end instead. Create a calculation field in the database. Something like

If[isEmpty[field]; " "; field]

and display this calc field in the portal instead.

The [FMP-if] may actually work. I found an error in my code. Used the wrong type of braket.

However, your suggestion worked like a charm. It was also probably faster to set up since I have 3 fields that can be blank.

Thanks!

JM