If portal empty

[Dani R]

how can i write a calculation the will tell me that if a portal is empty?

[LaRetta]

If there are no related records (portal records) for that one main record, you can find out by this calculation:

IsEmpty ( childtable::primaryKey ) ... produces 1 if there are no children.

You don't need to use the child's primary key but you need to be sure you use a field which is NEVER empty in the portal table.

[Dani R]

i have a layout with 3 portal's table .

1 the object name is "in".

2 the object name is "out".

3 the object name is "work".

how can i gat a costume dialog box if the out table is empty

[LaRetta]

how can i gat a costume dialog box if the out table is empty

The User must perform an action to fire a script which will produce the custom dialog. Can you explain the User actions and logic behind this functionality? Once you determine how you want the script to fire, you need to determine the table occurrence name of that 'out' portal (it will show the portal name in layout mode). Then the script would be something like:

If [ IsEmpty ( [color:green]tableoccurrence::non-empty field ) ]

Show Custom Dialog [ OK ; "There are no records in Out." ]

End If

When you need to insert the green portion in the script, select the correct table occurrence from the pop-up at the top of the calculation dialog and then double-click the non-empty (hopefully unique serial) field to insert it into the calculation.

... but we probably need a bit more of a vision here to pin down your needs. We are all more than happy to help you further if you get stuck. :wink2:

[Dani R]

i have a script that runs after the user fils in the layout.

so in the script that is running a check out if the portal table named "out" to be check if it is empty to show a costume dialog box.

i did test what you whore and i have a problem with it .

if the user in the "out" table enters 1 line and goes to line 2 is will sill say that is is empty . i need to check that there is no data on the table.

Edited January 8, 2010 by Guest

[LaRetta]

I'm sorry but I'm not sure I totally follow it, Dani.

if the user in the "out" table enters 1 line and goes to line 2 is will sill say that is is empty . i need to check that there is no data on the table.

It may be a commit issue but I don't think so. What field are you testing to be sure it is never empty?

UPDATE: To save time, it would help to see your file. :wink2:

Edited January 8, 2010 by Guest
Added update