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,689
    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

    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,689
    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

    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