Lookup Filteration

Hi @paragkenia,

Interesting question! ??

>>> Is it possible to filter the Lookup results (The column shown from the other table while doing data entry) based on certain condition.

Yes! This is documented here:
https://wpdataaccess.com/docs/documentation/data-projects/advanced-lookups/

>>> For eg to show options in lookup field that are filtered on certain date

Please see section “static conditional lookups” on the page mentioned above.

>>> or are entered by certain user.

This not supported. But it is an interesting suggestion! I wonder however, where does the user enter data? Can you give me a use case?

Thanks,
Peter

I have a similar question. I wanted to add a user input drop-down on the front-end page. So if I have a student-grade-subject table, I can let them select from drop down “>90” “80-90” or so on for grades and give a dynamic output for that particular user. Same for subjects, user can select “Math” and all students taking that class pops up. Is that possible?

Hi @charmi21,

How do you determine the user? Is this a WordPress user? Or another type of user?

If it is possible to write a view that returns the user dependant list, you can use a view in your lookup. The plugin supports views just like tables for lookups.

Does this help?
Peter

The “user” is actually anyone who visits our website. We don’t have any person who logs in. I want to be able for them to view whatever THEY CHOOSE because each person will be looking for something specific. Creating a view for each user is impossible in my case.

Hi @charmi21,

Sorry, maybe I did not understand your question correctly. Are you referring to a search form? Or data entry?

Thanks,
Peter

Search form

Hi @charmi21,

You can basically create any kind of search form, as long as you use the right URL parameter naming convention. For publications this is documentated here:
https://wpdataaccess.com/docs/documentation/data-publisher/adding-filters/

For projects it is documentated here:
https://wpdataaccess.com/docs/documentation/data-projects/adding-filters/

Please look at section URL parameters. Make sure your parameter name follows this naming convention:
wpda_search_column_<column_name>
Where <column_name> represents the column name you want to search.

It works equally for publications and projects. You can use the % character to add wildcards.

Hope this helps,
Peter