Dynamically Filter Data Based On User Input

I’m trying to build a system that could dynamically display data based on user input. Essentially, it is much like the Filter Variable Substitution, except using the username or email is not going to filter enough.

What I’d like to be able to do is have the user come to a page and there be a input box for “ProjectID”. They would input a unique project ID number and hit submit.

The page would then display data ONLY pertaining to that Project ID.

I assume it would be something like:

[cfdb-table form=”your-form” filter=”ProjectID=$project_id”]

But I’m not sure how to tell the server what the $project_id is for that session.

I hope that makes sense and appreciate any guidance.

Thanks

https://wordpress.org/plugins/contact-form-7-to-database-extension/