Custom Fields Limit?

This topic contains 7 replies, has 2 voices, and was last updated by  Stiofan O’Connor 10 years, 5 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #18584

    execfro
    Buyer
    Post count: 80

    Is there a limit to how many custom fields can be added and saved to a page? At the moment I’ve got about 80+ custom fields and I still need to add more, but I noticed that some of the checkboxes aren’t saving after a certain point. They’re all enabled so I’m not sure why some are saving and others are not.

    #18597

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    yes there will be a limit as they are all stored in the same row for speed and there will be a limit to the amount colums the table can have, theoretically it is about 1000 but realistically it’s probably best to keep it under 100, and with the other non custom values from Gd you are probably over that.

    I am not sure how you are organising your values, i would say they would be best in a arrays so to take one column up.

    Stiofan

    #18619

    execfro
    Buyer
    Post count: 80

    Well I’ve created quite a few checkboxes for my locations to check off any park features that they have. It’s an rv parks directory that needs checkboxes for various amenities, activities and accommodations that they offer so there are quite a few.

    I use those checkboxes to assign certain titles and descriptions in an array that I later call in my template.

    I’ve attached an image to show you a small sample of how I have my custom fields set up in Place Settings / Custom Fields and I’ve also attached an image to show you how I’m setting certain values to my custom fields in an array that I later use to display my data depending on what custom fields have been checked.

    A live example of how I’m displaying my custom fields can be seen here:
    http://highway.bigrigmedia.com/places/flying-flags-rv-resort-campground/

    #18624

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Unless you are using them in advanced search or sorting i would add them all n one multi select to save colums.

    Stiofan

    #18627

    execfro
    Buyer
    Post count: 80

    I do need them to show up in the advanced search so would they all still show up in a multi-select?

    I’ve attached an image of how my current advanced search looks

    #18630

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Do u need them ALL to show up in advanced search? If not i would stick the ones you dont in the multiselect.

    Stiofan

    #18632

    execfro
    Buyer
    Post count: 80

    Well our client does want to be able to filter extensively so I would say yes we do need them all in the advanced search. If you think it’s a bad idea to have them all though then we may be able to convince them of only using specific ones.

    #18633

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Well if you are having problems then i would consider it but if not carry on.

    Let us know if u run into anything major.

    Stiofan

Viewing 8 posts - 1 through 8 (of 8 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount