I have a contact -> equipment loan ->line items <- products     soultion.

 

In my line items portal which is on my equipment loan layout  I have a item_In_Out  field which auto calculates to say "Yes" if the return_date in the portal IsEmpty.   When a date is entered into the return_date field the item_in_out field clears.

 

This is so I can visually see which individual items are still on load per each Equipment Loan Order.

 

The problem I am having is portals seem to auto create a new empty portal row for you to begin entering new data.   When this happens the item_In_Out  field auto populates a "Yes"  because the return_date isEmpty  which is fine.... but  I have not entered any product information into the subsequent fields in that portal row.

 

If Portals will always create a new row at the bottom of your portal waiting for data, how do I write a script that will still allow the "Yes" to appear if the return_date is empty but remain blank   if no product id etc has been entered yet.

 

My propblem is similar to invoice solutions whose portal has a trash can graphic in the portal row..... The bottom empty row will draw that trash can.

 

The empty portal row occurs because the "Allow creation of records via this relationship"  checkbox is checked in the Edit Relationship dialog.  Uncheck it, and script the creation of new records with whatever conditions you require.

Great thanks!

if you want to have the create portal row - use a conditional format to make the "X" delete button background white by using the invalid function.