Random placement of portal row data

[We Can Deb]

Hello,

I am at my wits end trying to figure out what is going on with my Events_Guest portal!  For the most part, I have used the scripts and fields that came with the Events Management template.  The technique for adding a portal record uses the contact ID field placed below the Full Name field, allowing a search using the last name.

 

When participants sign up for a program, they are assigned a time slot.  When the event is originally established, all the time slots are entered with a blank contact name.  This way a volunteer can just sign a client up by clicking in the name field and using the pull-down list (which works) or if the contact is new, they click on the green plus sign and are taken to a new record request in Contacts.  When they click back to the Events tab, then onto the Participants tab, the new participant should be in the time slot they selected.  This is where the problem occurs--the new contact is being placed in other time slots, sometimes replacing another participant!

 

Attached are screen prints and a copy of the script and relationship that I think may be causing the issue.

 

Any help is very appreciated. 

 

Thank you,  Debbie

EventsGuests Bug.pdf

EventsGuests Bug Database.pdf

[LaRetta]

Hi Debbie, There could be several reasons for the break I'm afraid. Have you recently changed the sort on that portal? Have you stepped through debugger to see precisely where it breaks? And does it throw an error? If you can't spot it then can you zip an empty clone and attach it? We'll be happy to take a look. :-)

[We Can Deb]

Dear LaRetta:

Thank you so much for considering this problem!

Script debugger didn't give me any errors, and it looks like the get portal row number changes when the Contact new record request begins.

CONTACTS_WE_CAN.zip

I did change the sort, but when we began having the issue, I changed it back to no sort. I tried removing/adding sorts both on the relationship and on the portal. When that didn't fix it, I put the sort on the portal back in.

The users need the Participants to be sorted by time slot first and if there is no time, then in creation order. The Guests need to be alphabetical, and I can't get that to work well either (more of an annoyance than losing our clients that have signed up!)

Thank you for any suggestions.

Debbie

[Ron Cates]

Hi Debbie. A quick glance at your file shows that when your script returns to the Events layout and goes to the field it is going to the field in the Guests tab rather than the Participants tab. Then when it goes to the portal row it is going to that row in the Guests portal. You can fix this By giving the participants portal an object name and using Go To Object [ObjectName: Portalname] before Go To field.

CONTACTS_WE_CAN_mod.zip

[We Can Deb]

Dear Ron,

Your modification solves the problem! I see that your script goes to the object with the name of "portal.participants". Which object is named that way? My inspector displays only "participants" as the name of that tab.

Thank you!

[Ron Cates]

I gave the portal the object name portal.Participants. When you click on the portal in layout mode it is the name field at the top of the Positions tab in the inspector.

[We Can Deb]

I am definitely crazy.  When I do the exact same thing to my copy of the database, after Go to Object, the Go To Field script instruction takes you back to the Guests tab!  On your modified copy, this isn't what happens.  I have no idea what's going on!

[Fitch]

Give the field an object name and use that for the go to object step.

[We Can Deb]

Thank you all!  It works!  You are amazing!

 

Debbie

[We Can Deb]

Hi Everyone,

 

I am now having another problem with Events Registration.  I hope someone has a suggestion and thank you in advance!

 

Whenever we register guests for an event, we sometimes put in duplicate names as temporary placeholders.  For example, if someone buys 5 tickets but hasn't given us the names of all the guests.  Once we get the names, we change the guest records accordingly.  Unfortunately, the guest list (Guest Tab) won't sort properly (alphabetically by last name) based on the updated guests.  The same problem occurs if you add a new contact from this portal, using the green + sign.

 

Any ideas on how to fix this?

 

Much appreciation,

Debbie