[Resolved] Random Missing field information in VIEW

[Author]

Posts

[leilaG]

We have a VIEW with a list of Visitor information.

One of the fields is Building Access Required (Reception) and on random posts it is missing in the VIEW listing, but it is showing that the user has ticked in the front end form.

Visitor list VIEW page - hidden link (Building not showing)
Front end form - hidden link (Building ticked)
Backend form - hidden link (Building unticked)

[Shane]

Hi Leila,

Thank you for getting in touch.

I took a look and setup a test page here hidden link

This can be deleted once we are finished. I noticed on the few persons I saw that had the area blank had duplicate entries in the backend.

Have a look here hidden link

You will notice the duplicate entry and one has the building access information filled out while the other doesn't

This could be the cause of your issues.

Thanks,
Shane

[leilaG]

Thanks for looking into this, by duplicate entries do you mean they have the same post title? How do we get round this? as they need to be the Visitors name.

The example I gave only has 1 entry

Front end form - hidden link (Building ticked)
Backend form - hidden link (Building unticked)

[Shane]

Hi Leila,

As you can see here
hidden link

There are 2 Lynn Page's on the site.

So it seems the view is picking up only one and its a similar case with the others that don't have the info showing.

Thanks,
Shane

[leilaG]

Okay I see, how do we fix this?

[Shane]

Hi Leila,

The way I see it is that you will first have to delete the duplicate and then check on the frontend to see if it works.

Start with only one duplicate and then check to see if works.

I do however noticed that the ones that are duplicates were created in 2020.

Thanks,
Shane

[leilaG]

Hi, we can't delete them, visitors attend more than once, so they would have more than one post/record.

The permalink is always different, so why would having the same post title (Their name) cause it to be a duplicate?

[Shane]

Hi Leila,

Since there are multiple records and one that doesn't have the item checked means there is a duplicate.

Are the users creating a new account or a new profile each time ?

The reason why they have the same titles is that if the Post title field is the name field for the user to enter then it will always have the same title.

Please let me know.
Thanks,
Shane

[leilaG]

No they are not creating a new account, (user registration is separate, they have an account and they are just filling out the visitor form, to add a visitor.

Yes the post title is the Name of the visitor.

[Shane]

Hi Leila,

Ok so they would create the visitor profile only once.

Then this means the CRED form should create the visitor profile only once. Its quite strange that there is a duplicate.

Is there any hooks that you have setup that would create a duplicate of the initial post that the user made ?

Assuming that they can only edit their profile but not create a new one I'm not seeing a way that they would be able to create a duplicate as this is really in my opinion what is causing the issue.

Thanks,
Shane

[leilaG]

Hi, I think there is some confusion.

They are just a list of visitors and the same named visitor can attend more than once, which is why a user can add the visitor to the list on more than one submission.

They are not duplicates, the arrival dates are different.

[Shane]

Hi Leila,

I understand this, however this is the cause of the problem.

They are not selecting the checkbox that will allow the the information for the custom field to show up in the table.

Because you're loading this and some posts don't have this information selected.

I would advise that your customers select this checkbox as well when they are adding the visitors again.

Thanks,
Shane

[leilaG]

Hi Shane,

They are ticking the checkbox. If you go back to the top of the thread, that was my example, that they are ticking the checkbox on the frontend form, but it's not showing in the backend form or the VIEW

Front end form - hidden link (Building ticked)
Backend form - hidden link (Building unticked)

Is it possible to get a second supporter to have a quick look

Thanks

[Shane]

Hi Leila,

The problem is definitely because the user is not checking the checkbox.

If I go here
hidden link

and edit it on the frontend.
hidden link

Then hit save you will see the changes are reflected on the backend. To me this seems to be a user error. Maybe you need to set a default selection so the user doesn't forget to select an option.

I cannot find anything else that would suggest that this isn't the issue. There is also a second case here
hidden link

hidden link

Thanks,
Shane

[leilaG]

I understand what you are saying, but when I created this ticket and sent those links

The front-end form had been checkbox had been ticked and it was not reflected on the backend form or VIEW