hiding Delete Icon for a portal last row- did i reinvent the wheel?

August 21, 200619 yr

I need to have Add Record on, but I don't want buttons in the last row to show (Export File and Delete).

As a test I created a calc in a field of the portal file

case ( isempty ( THE_Data_Field ) ,"", UI:Delete_Icon )

Works, no delete icon shows on the last "row". I'm just annoyed that I would have do that all over my tables where needed.

Aside from the fact that I tested for a single field instead of a record present (TBD),

Was there a more logical, easy method?

I have a UI file, a Data file, and a FileLibrary (too chicken to store many file attachments to my "real" data.)

The UI has image files to use as icons (instead of pasting/inserting on layouts), with 1 record in file (don't want the hassle of resetting globals).

With a relationship of [X] I can use the one icon all over, but it seems that in a portal, they will show on the "potential" record in the last row. Same if I use a calc, so thats why I tested for empty first.

August 21, 200619 yr

No, I think the way you did it is pretty much what you have to do now. I would use an ID field, or one you're certain has data; or should have data for the button to appear.

Another "related" trick is to create a calculation field in your 1-record table, equal to the container (or whatever) constant. Then set the calculation's storage to [x] Global. That way you can access the calculation field from anywhere without a relationship. Not a big deal, but cuts down on the number of lines needed on the Relationship Graph.