Do not commit portal

[zab]

Hello

I am creating portals using Kieren MacMillan's Fast create type of portal. I am also using a calculation script to add additional data to the Line item . My problem is if I don't click on the required button to perform the script the record is commited and don't appear at the correct place in the report. What is the best way to not commit a record to the portal when clicking anywhere on the layout? I also have other fields not in portals in the layout... so I'm not sure if the layout script trigger is the solution.

Thank you

[comment]

I am creating portals using Kieren MacMillan's Fast create type of portal.

A link would be helpful for those of us who are not familiar with the reference.

What is the best way to not commit a record to the portal when clicking anywhere on the layout?

Use an empty web viewer object as the layout's background.

[zab]

I'm back to this problem so the way to enter data in the portal is by partly using this Kieren MacMillan's Fast Create To this I added scripts (one per portal) to the background button to automatically fill extra fields (used for reports etc). It work just fine.

The problem with that technique is if someone click anywhere else but on the button, the fields commit and the extra information is not added because the script was not called. So I named all the entry fields to the portals each starting by the number of the portal (p1_IDitem) and then created another script that look like

if (Left(Get (ActiveLayoutObjectName); 2) = "p1"

Perform script ....

This last script work very well if I assign it to a button but it doesn't work if I apply it to a OnRecordCommit Script Trigger.

So you see I'm searching for a way to not commit to the portal by just clicking anywhere.

Thank you

[comment]

I'm back to this problem so the way to enter data in the portal is by partly using this Kieren MacMillan's Fast Create

IMHO, this method became obsolete when script triggers came aboard.

So you see I'm searching for a way to not commit to the portal by just clicking anywhere.

Use an empty web viewer object as the layout's background.

[zab]

Thank you I will try.

The only reason I choose this way is because users fill the fields on top of the portal and not on the last row... I can have a lot of infos to enter in there. How would you do this?

[comment]

I don't think I know enough about "this" to make a suggestion.

[zab]

Still looking for a better way cause this way cause too much trouble, so I tested using Script triggers on the portal with OnObjectExit and it work real fine... I was excited. Then I put my little "x" to delete the portal row and it doesn't work what the hell. It was too good to be true. I seen this problem some place else. Any idea why or what is the solution?

Thank you

[bcooney]

I know that you think that you're giving us enough to go on, but if you reread your posts, you'll see that you haven't given us much of a description of your setup.

That being said, I would suggest that you reconsider having users enter data via the portal. Instead, have the user create a child record in a popup window on a layout based on the child table. Give them a Cancel and Save button on the popup, and after they Save, the window closes and can be viewed in the portal. No script triggers necessary.

See attached demo

PopChildEntry.fp7.zip

[zab]

hello

there is way too much entry to do and a popup would drive them crazy. they create records (and often duplicate) directly in the portals and I have attached some script triggers to the fields to finish the data entries. Still I don't understand why a delete button can't work if a script trigger is applied to the portal itself. The idea was to add this script trigger, if a field is empty display a dialogue . I just can't do that. I dropped this matter for now. No more time for it.

I will look to your attachment as I still have to do a popup for some other entries. My trouble now is how to select an item in the thousands available without having to scroll them all.

It's not a problem on a mac as the scrolling is fast and I can go to the first letter of an item. But PC world being what it is I need another solution. I remember there was a long script about it on the Bible... that is my task today. Hopefully your attachment will provide a simple solution... cross my fingers.

Thank you for your help I appreciate it.

Isabelle

[bcooney]

Have a look at this demo.

PopupSelectNew2.fp7.zip

[zab]

Have a look at this demo.

Very interesting. Looks like the Bible's way without too many words ;-)

Thank you

[zab]

Have a look at this demo.

I love you.

I can't believe how easy it is. Should have think of it myself.

You made my day.

Many thanks

[bcooney]

B)