Okay
  Public Ticket #2176487
URL Link
Closed

Comments

  • Alex Gurovich started the conversation

    Hi, I purchased the 14 day trial period, so I have full access to the tool. What I would like to do is that when a user is viewing a Table, in this case a table with Patients of a Doctor. The idea is that the Doctor can click on a Patient (that is a row), and get to a page where the details of that patient show up.

    How do I do that? 

    I cant create that link, that has as a parameter the Patient that the doctor is clicking on.

    Check here. It's the Column "Apellidos" (that means "last name", that should be clickable, and send to a Page within wordpress where the Patient details get exposed):

    http://www.indidev.cl/wp/listado-de-pacientes/

  •  2,572
    Aleksandar replied

    Hello Alex.

    Thank you for your purchase.

    From what I can see, you added the link to the last name:

    7012705530.png

    However, when I open that page, I get a "404 - Not Found" error. This simply means that the page is yet to be created, and there's nothing there:

    4570036593.png

    You need to create the patient's page, where the link will actually take the doctors. If there's something I'm missing here, please let me know.

    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

  • Alex Gurovich replied

    Hi Aleksandar, probably I wasn't clear enough.

    See the picture I'm attaching.

    How do I create in the WpDataTables Plugin a  URL link for the  field "Apellidos" (that means "last name" in spanish), so that when, you click on either Gonzalez, or Rodriguez, or Jimenez,  , it calls always a same page (that will be the contact details page) , that will be loaded with the data of the Apellido you clicked on.



  •  2,572
    Aleksandar replied

    Hi again Alex.

    I'm sorry, but I do not quite understand.

    You said this:

    when, you click on either Gonzalez, or Rodriguez, or Jimenez,  , it calls always a same page (that will be the contact details page)

    From this, I understand that it doesn't matter which last name you click on (Gonzalez, Rodriguez, Jimenez), it always opens the same page (for example http://www.indidev.cl/wp/listado-de-pacientes/). But I don't believe that's what you wish to do because of this:

    it calls always a same page (that will be the contact details page) , that will be loaded with the data of the Apellido you clicked on

    So, this then tells me that every last name should have their own separate page. Like this:

    Gonzalez - http://www.indidev.cl/wp/listado-de-pacientes/gonzalez

    Rodriguez - http://www.indidev.cl/wp/listado-de-pacientes/rodriguez

    Jimenez - http://www.indidev.cl/wp/listado-de-pacientes/jimenez

    If you wish the link to take you to the same page (http://www.indidev.cl/wp/listado-de-pacientes/) no matter what last name is in the field, you can open the "Apellidos" column settings, go to "Editing", and add a pre-defined value:

    6992837607.png

    So, every new entry would have that as a pre-defined URL. However, you would need to add "double sticks" ( || ) after the link, and add the name, like this:

    9908490618.png

    And the value in the cell would look like this:

    9982296276.png

    So, when you click on Gonzalez, it would take you to http://www.indidev.cl/wp/listado-de-pacientes/.

    Please help me understand if I misunderstood again. Maybe provide some screenshots and instructions for me.

    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

  • Alex Gurovich replied

    Hi Aleksandar:

    Probably I haven't been able to explain my self clearly. What I want to achieve is this:

    There is a table with "last names": Gonzalez, Rodriguez, Jimenez, and many many maaaaany more that my users will create, which means, I don't know what are the the "last names" that will end up existing in the table

    So, I want to be able to call a  page, with a common URL, and using the "last name" as a PARAMETER in the call to that page, so that target page loads with the "last name" (and that way, this page displays the details of the record the user clicked on in the table in the first place)

  •  2,572
    Aleksandar replied

    I believe I understand now, Alex

    So, whenever a user clicks on a last name, he is taken to the "last names" table, but with the # property that scrolls to that specific user inside that table?

    This could be done using CONCAT function, if you create a table using an SQL query.

    Do you have that common URL created? If so, please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except 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

  • Alex Gurovich replied

    jjajj, no, this that you say is not what I need "whenever a user clicks on a last name, he is taken to the "last names" table, but with the # property that scrolls to that specific user inside that table?"

    What I need is:

     "whenever a user click on any of the  last names that show up in a Table, he should be taken to a "details page" where the details of that record show up (the record the user just click on). 

    How do i invoke that page from wpDataTables plugin? From the field "URL Link" inside the plugin (check screenshot I attached 2 replies below) ? How do I make the "Last Name" a parameter in that call to that "details page"?

  •  2,572
    Aleksandar replied

    Hi again Alex.

    We don't seem to understand each other very well. Sorry about that.

    If you wish to create a link in the column header - that is not possible:

    7022986990.png

    Entries inside the table can be links, and there are two possible scenarios here:

    1. Each entry takes you to the same page:

    Gonzalez - http://www.indidev.cl/wp/listado-de-pacientes/

    Rodriguez - http://www.indidev.cl/wp/listado-de-pacientes/

    Jimenez - http://www.indidev.cl/wp/listado-de-pacientes/

    2. Each entry takes you to a specific page:

    Gonzalez - http://www.indidev.cl/wp/listado-de-pacientes/gonzalez

    Rodriguez - http://www.indidev.cl/wp/listado-de-pacientes/rodriguez

    Jimenez - http://www.indidev.cl/wp/listado-de-pacientes/jimenez

    wpDataTables cannot create a "details" page all on its own. You would need to create these pages. So, for example http://www.indidev.cl/wp/listado-de-pacientes/gonzalez would have to be a new page you create, and add data to it.

    For example, each of these last names has specific details (Name, Last Name, Address, Phone Number, e-mail), and you need to create that. You can create tables for those details, or you can create custom pages.

    9014713991.png

    So, from your original table, a user clicks on "Doe", and it takes them to this new page, where the details reside.

    To have users go to that page, you need to edit each row and add the correct URL in it. You cannot simply enter the last name, and have the plugin understand where it needs to go.

    The only way of doing this would be to have the list of names in a database table. Then, you can create an SQL Query based table and to have a dynamic URL in the column using a CONCAT function.

    So, if you have a table in the database which consists of last names, you can create a new table in wpDataTables like this:

    SELECT CONCAT('http://www.indidev.cl/wp/listado-de-pacientes/',`your_custom_database_table`.`apellidos`,'||',`your_custom_database_table`.`apellidos`) AS `Apellidos`
    FROM your_custom_database_table

    This would add the last name to http://www.indidev.cl/wp/listado-de-pacientes/ and display it only as the last name.

    Kind 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