Conditional Container

[musicarteca]

I want to place a global container field with the "delete" icon at the end of a portal row, it will be attached to a script to delete a row.

The thing is that I don't want the image to appear on the last empty row of the portal. Therefore I would like to place a calculation container field that won't display the image if the row is empty (last row).

The questions are: What would be the best calculation? do I have to make a calculation for each table, or a general calculation will work for all portals?

Edited March 12, 2006 by Guest

[Ender]

Use a global container field to hold the image (doesn't matter what table this resides in,) and a calculation with container result equal to the global (this calc must reside in the related table.) Place the related calculation field on the portal.

[Genx]

You might also consider not allowing creation through this portal and make a dedicated relationship specifically for creating new records. Then just automate the process through a script.

~Genx

[musicarteca]

Thank you very much for the answers, Genx, could you expand a little bit more on your proposal. Are you talking about entering the data in a group of global fields and then using a script to place them in the portal, or something else?

Alejandro

[Genx]

No, I just meant that you might create a blank record in the other table so that that you can then enter data into the newly created row in the portal.

The dedicated record creation relationship was simply one way of achieving this end.

[jwren]

Hi Ender

I have a similar situation but I must be missing something!

Working on a volunteer database and I want to show a red flag (global container field) when a volunteer has reached 5 or 10 years of service. The Years of service field is a calculation field (year current date - year date accredited). I only want the graphic to appear when that calculation equals 5 or 10 etc.

Is this possible? Appreciate your posts.

[Ender]

Service Pin (calculation, container result) = case(Years of Service = 5 or Years of Service = 10; red flag)

[jwren]

Thanks Ender - on to it now.

jwren