Page 1 of 1

How to pass the same record after insert to a pull down menu?

Posted: 2019-03-02 18:07
by nycwebmaster
Hi,

Let me explain first the database configuration so you can understand what I need to do:

I have a table called Events one of the fields on the event table is called company name

I have a table called Contacts and one of the fields is called company name that pulls the information from the company name field from the event table

After the customer enters an event he is redirected to the Contacts table

On the contacts table the customer has to choose from the pull down menu his company name.

Is there a way that the customer could have already selected the company name that he entered on the Events table instead of having to choose it from the pull down menu when he is redirected?

Re: How to pass the same record after insert to a pull down menu?

Posted: 2019-03-20 12:36
by a.gneady
Yes, you can add a 'filterer' parameter to the URL you're redirecting users to. So, if you're redirecting to 'contacts_view.php?addNew_x=1', modify that to 'contacts_view.php?addNew_x=1&filterer_company_name={$event_id}' ... Assuming $event_id variable stores the ID of the newly added event, and 'company_name' is the name of the lookup field in contacts. For more details, see https://bigprof.com/appgini/help/advanc ... parameters