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

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
Veteran Member
Posts: 39
Joined: 2015-11-23 01:02

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

Post by nycwebmaster » 2019-03-02 18:07


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?

User avatar
Site Admin
Posts: 996
Joined: 2012-09-27 14:46

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

Post by a.gneady » 2019-03-20 12:36

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 ... parameters
:idea: Learn all the tips and tricks of customizing AppGini apps through our online course.

:arrow: Summary Reports plugin enables you to build powerful reports and charts inside your AppGini application through a few simple steps. See the big picture and discover trends in your data that empower you to take the right decisions confidently.

:arrow: Search Page Maker enables you to build user-friendly yet powerful search pages for your AppGini application by simply dragging and dropping the fields you want to include in search.

Post Reply