Page 1 of 1

Show Records basis a Field Value

Posted: 2018-05-30 07:39
by uchhavi
Hi,

I have 2 questions:

Question 1
We have dealers from 6-7 countries... When the dealers open the system from their login, I was them to see records belonging to their country only-

I have a company_tb and a company_contact_tb and the both have a field named Country.

Question 2

I have a tables called Purchases and in that i have a field company... in the company field dropdown I want to show data, where the User Category (another table) User_Id = 'Supplier' and also in another I want to show all company records where the user category is NOT suppliers.

How to solve these. Please help

Re: Show Records basis a Field Value

Posted: 2018-06-04 00:24
by R Tammam
Hello Chhavi Jain,
could you please mention company_tb and company_contact_tb fields please

Re: Show Records basis a Field Value

Posted: 2018-06-04 15:30
by uchhavi
country_id which it picks from the country_tb in both the company_tb and company_contact_tb

can u please help?

Re: Show Records basis a Field Value

Posted: 2018-06-05 00:44
by R Tammam
i think you should use addFilter() function to apply filters for what you want to show
and here's it's AppGini documentation
https://bigprof.com/appgini/tips-and-tu ... ult-filter
i hope it would help you

Re: Show Records basis a Field Value

Posted: 2018-06-05 05:58
by uchhavi
i think what you have told me is for the new entries in the table...

how about the old table? or the existing data? will this work there as well?

Re: Show Records basis a Field Value

Posted: 2018-06-06 02:52
by R Tammam
uchhavi , could you please tell make data you really want until i could help you , i might misunderstand you