Hiding Records

You need to check your filter logic to make sure it is right. Since your field is designed to hide the record if it is a “yes” you need to make sure your shortcode filter is something like “hide=No”

Thanks for the response. We have the filter logic correct, and have been filtering with a “hide=No” statement. We can readily hide or show records as required. That is not the challenge. Our problem is that new records don’t display until we go into the admin and check and then uncheck the Hide checkbox. The same issue with radio buttons. The default No is not being activated without admin intervention.

OK, how about “hide!Yes”

No change if the filter query is changed to “hide!Yes” as you suggest. In Manage Fields, we have a Hide yes/no radio button in the admin area, with a default of No. Settings: Not required; captured in CSV export.

End users navigate to a signup form, and on Submit their records need to display. The page is set with the following filter:

[pdb_list search=true filter="hide=No" template=detailed list_limit=50 orderby="first_name" order="asc"]

In the List Participants admin, we have display columns for: Hide| Given Name|Family Name| Branch |Date Recorded |Date Updated |Private ID. Under the Hide column, No displays on new records, which is expected due to field default settings.

However, when we click to edit a participant record, the default value has not been transfered, and neither a No nor Yes radio button option has been selected. We need to manually tick the No radio button option/or if using a checkbox, tick to select it. The default is not being transferred to the participant record without admin intervention.

This behaviour is browser independent.

OK, on the manage database fields page, what do you have in the “values” section of your hide field?

“hide!yes” will work for this, I just need to see how you have that element set up.

Manage databse fields page has “No/Yes” in the “values” section. Form Element is now “radio buttons”; default is “No”

You nave to use a comma, not a slash: “No,Yes”

We have confirmed the values have: “No,Yes”. Form element is radio buttons, default is “No”. Have updated the filter shortcode to include “hide!yes”. The default value is still not being passed to individual records. Admin must still go into each record and select “No” in order to display new records.

Just to follow up. The default “no” from the radio button is being passed to the record in the admin “Add Participants”, but not to the individual records. It displays “List Participants” page, which captures self sign-ups, but these individual records still don’t capture the value.

The default value for fields that are not present in the signup form are not saved with new records that are created with that form. That is why you need to use a filter that tests for the absence of the value.

Thanks for all the assistance. We’ve followed the filter shortcode setting for “hide!yes”, and understand the default value for fields that are not present in the signup form are not saved with new records that are created with that form. We can display records that have No in the hide field, but still need to manually go into new records and select the “no” option. Is there any way we can avoid this extra admin step?

yes, you can use something like: “hide=NO|hide!” which will show all fields that have “No” for the hide value and all records that have no hide value defined.

Thanks for all the assistance. We’ve gone back to the “hide!yes” because “hide=No|hide!” displays records tagged hide=yes and hide=no, but still doesn’t display new signups without admin intervention. Think we’ll wait for a future release and progress with manual assistance to display records.

Yeah, I’m sorry about this…it looks like the null values in new records can’t be filtered…as long as there is a filter on a field, all null values will be excluded.

This is fixed in the next release where it is possible to filter by null values.

There is a workaround that involves a simple change to the structure of the database table. Open your database in an MySQL editor like PHPMyAdmin. Find the wp_participants-database table (your prefix may be different) and under the “Structure” tab, find your “hide” field. Click on “change” to edit the column parameters. Uncheck “NULL” and set the default value to “none”

Now, all your records that had NULL for the blank fields will have a blank value instead, and can be filtered with “hide!no”

Thanks. that’s help me.