Hello all
I am new and I did some power searching on join and link in relation to the advanced filters. I did not really see a quick and simple way to join tables together in the way I envisioned. Example I want to use the advance filters and be able to use fields from different tables. See below
Table 1 column - dog
Table 2 column - food
Table 3 column - Toys
Advance filter
Filtered field comparison operator comparison value
filter 01 dog = poodle
filter 02 food = kibble
filter 03 toys = bone
Based on these fields in different tables I want the data to be displayed. How do I do this? Would this require some modification in the code or did I over look something? Thanks for your help.
Link or join tables
Re: Link or join tables
Hmm ... you probably need to combine the fields into a fourth table using lookup fields. You can then search the fourth table the way you described above.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
-
- Posts: 2
- Joined: 2015-10-06 18:07
Re: Link or join tables
Okay I understand what you are getting at but I was looking for a way to do this with appgini without creating a fourth table with all these fields.
Re: Link or join tables
Hi Admin
Is it possible with either code in the hooks folder or in appgini itself to create a way of auto filtering data in a table according to a certain client.. i.o.w there is one table with 3 different clients but each client has about 10 records in this table and all the records of all the 3 clients are all mixed.. i want to filter them not with the front end but actualy have 1 link or button that when clicked it will do 3 things, nr 1 filter all the same clients records together, nr 2 send an email or push notification to that client with their own records and what was changed and nr 3 create a screenshot copy of what was just sent to each client and store it on the database?
I hope all this would be possible?
Kind Regards
Richard
Is it possible with either code in the hooks folder or in appgini itself to create a way of auto filtering data in a table according to a certain client.. i.o.w there is one table with 3 different clients but each client has about 10 records in this table and all the records of all the 3 clients are all mixed.. i want to filter them not with the front end but actualy have 1 link or button that when clicked it will do 3 things, nr 1 filter all the same clients records together, nr 2 send an email or push notification to that client with their own records and what was changed and nr 3 create a screenshot copy of what was just sent to each client and store it on the database?
I hope all this would be possible?
Kind Regards
Richard
Re: Link or join tables
Hi Richard,
can you please start a new post with your question as it is not related to this one.
Aslo it would be helpful if you show a screenshot of what you try to acheive.
can you please start a new post with your question as it is not related to this one.
Aslo it would be helpful if you show a screenshot of what you try to acheive.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Link or join tables
Hi pbottcher i have tried starting a new post? how do i start my own post?
Re: Link or join tables
Hi,
looks like you managed to find how to create a new post :
https://forums.appgini.com/phpbb/viewto ... dd09dc90a3
looks like you managed to find how to create a new post :
https://forums.appgini.com/phpbb/viewto ... dd09dc90a3
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Link or join tables
Haha yes i did!! thanks for checking up on me lol