hporter18

Hi Kim,

Can you give me an example of how to pass a query string parameter to a wpdadiehard? form?

The wpda_search_column_paramName will not work in my case, neither will hard coding parameters.

Here is my use case:

• I am building a scoresheet page for a minor hockey league
• as goals are scored i need to enter them in real time
• my scoresheet has a wpdadiehard? form to enter/display goals for the home team
• it has another wpdadiehard? form to enter/display goals for the visitor team
• The Goals table has a teamID (ie no way to determine if it’s a home team or visitor team)
• so when my page has url like below [[https://wywhockey.test/gamesheet/?scheduleID=24&visitorTeamID=24&homeTeamID=4]]., I want my Home Team wpdadiehard? form to use TeamID = **homeTeamID=4**
• I want my Visitor Team wpdadiehard? form to use TeamID = **visitorTeamID=24**
• The above works for datatables, but I need it to work for a data entry form

Hope that makes sense

When I try this [wpdadiehard project_id=”34″ page_id=”39″ filter_field_name=”scheduleID, teamID” filter_field_value=”httpRequest[‘scheduleID’], httpRequest[‘teamID’] “]

I get this error message, I’m assuming because of the extra square brackets:

 ERROR: Data Project page not found [need a valid project_id and page_id], httpRequest[‘teamID’] “]

Hi Kim,

It works if I hardcode the values, but not if I use the query string variables. What am I missing?

This returns expected results: [wpdadiehard project_id=”34″ page_id=”39″ filter_field_name=”scheduleID,teamID” filter_field_value=”53,44″]

This returns 0 results: [wpdadiehard project_id=”34″ page_id=”39″ filter_field_name=”scheduleID,teamID” filter_field_value=”$$scheduleID$$,$$teamID$$”]

This is my URL:

https://wywhockey.test/gamesheet/?scheduleID=53&visitorTeamID=44&homeTeamID=35

This was the same result when I tried to use the default where clause.

Thanks,

Harvey

Was able to get it working using URL parameters and wpdadiehard?, was using wpdadataproject initially. I suspect I’ll get the select lists working using your documentation on Dynamic conditional lookups.