We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #1651106
Add or Edit a Table Row MySQL
Closed

Comments

  •  6
    cpshart started the conversation

    Hi

    I am using wpdatatables Version 2.2.3

    I should like to have a single wpDataTable to allow me to add and/or edit a row code on the transactions table.

    so I can define the Edit Column code as follows for selecting a code from the page load

    EDITING, Editor Input Type Single-valueselectbox

    Data Read from table on page load

    But to add a new code, this definition would need to change to

    EDITING, Editor Input Type One-line edit

    So I can define 2 wpDatatables one for Edit, one for Add and thus 2 webpages, but is there an alternative option, so users can edit and/or add on the same webpage.

    I may be missing something obvious..


    Many Thanks in advance


    Colin

  •  1,894
    Miloš replied

    Hi Colin,
    Thank you for your purchase.

    Sorry but I did not quite understand what are you trying to achieve.

    Can you please describe me more or send me some example/screenshot so I can take a look and give you my suggestion.


    Best regards.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    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

  •  6
    cpshart replied

    Hi Bogdan

    Thanks for your reply, I have added some screen shots to explain the query.

    On my website portfolios screen, when selecting New I may wish to add a new row to the table by using a portfolio_code already loaded on the table (in this case TDW_DEA_POORMAN or TDW_ISA_POORMAN)

    (ref dividendm-listcodes_1651106 )

    set-up 

    (ref datatables-listcodes_1651106)

    OR

    create a new portfolio_code say TDW_SIPP_POORMAN, in which case can I do this using a combination dropdown list and if not selected, type a new value


    (ref dividendm-newcode_1651106 )

    set-up 

    (ref datatables-newcodes_1651106)


    otherwise

    I may need to create 2 x wpdatatables for New Entries, unless I am missing something obvious ???

    1/ New Entry using existing portfolio_code

    2/ New Entry creating a new portfolio_code

    I hope this makes sense.

    I have another couple of questions in this New Entry Screen area which I will open other tickets for,.


    Many Thanks


    Colin


  •  1,894
    Miloš replied

    Hi Colin,

    Is there any live example of this table so we can take a look and understand it better.


    Best regards.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    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

  •  6
    cpshart replied

    Hi Bogdan

    The system is on localhost only, so sorry no live example. i suspect it is not implemented, but my thinking is as follows :-

    1. If you select New to create a new portfolio record, you would need to enter a new portfolio_code value given by  attachments

     dividendm-newcode_1651106.png

     datatables-newcode_1651106.png

    EDITING, Editor Input Type One-line edit 

    2. If you select Edit to edit an existing portfolio record, you may need to enter an existing portfolio_code value given by  attachments

    dividendm-listcodes_1651106.png

    datatables-listcodes_1651106.png

    EDITING, Editor Input Type Single-valueselectbox

    Data Read from table on page load

    This is not a critical issue and I think my thinking may be flawed on this in terms of how I want the system to work, I can use option 1 for both Edit and New options

    So unless you have some immediate thoughts I am happy to close this call, with thanks.

    I will open another call for some other issues which should be easy to confirm whether they are and option or not implemented.


    many thanks.

    Best Regards

    Colin