Okay
  Public Ticket #1831500
values list based on another fields value
Closed

Comments

  • Robert Crimmins started the conversation

    The table I’m creating is for a coin collection. One of the columns (fields) is for coin “Type” which varies according to the coins denomination. Is there a way to make the list of “Defined Values”  change based on the Denomination field? So if the coin is a Half Cent the Defined Values that are in the drop down menu for the coin’s Type are “Liberty Cap”, “Draped Bust”, “Classic Head” or “Braided Hair” but if the Denomination is “Large Cent” the Defined Values that are in the drop down menu for that coins Type will be “Flying Eagle”, “Indian Head”, “Lincoln Wheat”, “Lincoln Memorial” and “Lincoln Shield”.

  •  2,537
    Aleksandar replied

    Hello Robert.

    Thank You for Your purchase.

    If You'd like to add conditional formatting when entering new data into the table, this cannot be done by linking two columns, for example, if one column has "Half cent", the other column would let You choose "Liberty Cap", "Draped Bust", "Classic Head" or "Braided Hair". 

    If, however, You already have all the data in the table, and would like to filter by these columns in this way, You can take a look at Powerful Filters addon for wpDataTables. It allows cascade filtering, so when You select one option, only options for that value would be displayed, hiding all the others.

    I hope this helps.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • Robert Crimmins replied

    Thanks very much. I'm not surprised that conditional formatting is only available after the data is entered but I'm glad to hear back from you so quickly and with such a clear and complete answer. I think wpDataTables is going to work well for what I need to accomplish with the coin collection and other applications that come up. The site I'm building (that isn't related to the coin collection) is for my photography and I envision organizing the pictures in tables that will allow customers to search by location, subject, size and other criteria. Your plug-in is the best way I've seen to do that. Are you aware of any sites that have used it for that?

  •  2,537
    Aleksandar replied

    Hello again Robert.

    I haven't run into any sites that used wpDataTables for photography, but I have worked with people who created pages for used car sales, real estate, apartment blocks, etc. and they all consisted of pictures, location, size, etc. so I have no doubt it will do good for You.

    If You have any issues or questions, of course, please feel free to reach out to us.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  • Robert Crimmins replied

    Would you mind providing links to the sites? Seeing examples would be useful.

  •  2,537
    Aleksandar replied

    I am sorry Robert, but I don't keep track of all tickets I've reviewed.

    Also, there are some problems with that request. As much as I'd like to provide examples, I must point out that most of those tickets weren't public, so I would have to contact the users to ask for permission of sharing their web-sites; also, a lot of them were accessible only to logged-in users; most recent ones were still in production, so You would only be able to see the "Under construction" page even if I were to share the links.

    I can invite You to search this platform for public tickets. For example search for "Image in a column" or "Displaying pictures", or anything similar. I believe You'll be able to find some tickets that are public.

    I can do as much as contact the most recent ticket owners and check with them if it would be OK for me to share their web-sites with You. I'll get back to You as soon as I hear from them.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables