12 Replies Latest reply: Aug 7, 2012 7:20 AM by Misi Mladoniczky RSS

list view table

ds NameToUpdate

How to save Row in table list view to form and how to save data in list view table ??

  • 1. Re: list view table
    Aditya Kovur

    You Do not save data in a table. If you want your row to be updated, you will have to update the back end form that you are pointing your table to.

     

    Regards,

    Aditya K

  • 2. Re: list view table
    ds NameToUpdate

    ok,, i used the back end form ,,,i used two form and workfolw to reomve row from table1 and add it to table two and work flwo work fine but when i close the form contain the two table the value slected(add from table one) in table two it be lost ,,plz help me about this

  • 3. Re: list view table
    igangwar

    Your requirement is not clear please elaborate...

  • 4. Re: list view table
    Misi Mladoniczky

    Hi,

     

    The simplest way to do this, would be to have a flag in the underlying form that stores the table the record belongs to. For example Table=Right/Left.

     

    Then your right table qualifier would be ('Table' = "Right"), and the left ('Table' = "Left").

     

    When you move things between the tables, you only need a simple Push-Fields action and two table-refreshes.

     

    This might not suit your situation at all though, depending on a lot of things...

     

           Best Regards - Misi, RRR AB, http://rrr.se

  • 5. Re: list view table
    ds NameToUpdate

    my requirement ,,i have two table Right/Left.Right and Left. i want to pass data from table right to table left i succeed for this by create Run process but when i close the form that contain two table and retarn to open it i lost the data in tabled,,,plz how can i do this in details

  • 6. Re: list view table
    Misi Mladoniczky

    Hi,

     

    Where in the database do you store information about which data to display right or left?

     

    If you do not store it, it can never be persistent.

     

            Best Regards - Misi, RRR AB, http://rrr.se

  • 7. Re: list view table
    ds NameToUpdate

    i get this data from form product catloge in both tables and data store it
    the column in table represent product name in form oroduct catloge

  • 8. Re: list view table
    Misi Mladoniczky

    Hi,

     

    I understand that the rows are stored in "Product Catalog".

     

    But where do you store information about Right or Left?

     

    You have actually told us nothing about your requirements except the fact that you have two tables on screen. It would be much better if you discribed your ultimate goal.

     

    For example:

    1. A user will choose products from our product catalog by selecting them and moving them to the right table (the selected items will be stored in form/record with the following criteria)
    2. Then they will close the window because this and that
    3. Then they will reopen the window and continue to move products to the right table
    4. Finally they will press "Order Products", and the following will happen...

     

            Best Regards - Misi, RRR AB, http://rrr.se

  • 9. Re: list view table
    ds NameToUpdate

    the selected items will be stored in form/record with the following criteria,,how i can do this

  • 10. Re: list view table
    Misi Mladoniczky

    Hi,

     

    PLEASE describe your situation and your ultimate goal!!!

     

    Either you store the information about Right/Left in the "Product Catalog" form in a special field you create for this. You will then store "Right" or "Left" in that field with a Push-Fields action.

     

    If you have multiple users doing this, it might not be a good idea to store it in the "Product Catalog". Instead you need to create a form called "Product Catalog User Selection" where you store information about which rows have been selected. It could be one record per user, or one record per chosen product for each user.

     

    Much depends on what your ultimate requirement is. What will you do with the table data when the user is finished?

     

            Best Regards - Misi, RRR AB, http://rrr.se

  • 11. Re: list view table
    ds NameToUpdate

    im create advanced interface form with backend mapping (SRM),,must contian two table ,,left table contain item and the user choose this item in table and add it to rgiht table,,,and how to store row in form(Product Catalog User Selection)what workflow

  • 12. Re: list view table
    Misi Mladoniczky

    Hi,

     

    It would be a combination of Push-Fields, Table Refreshes etc. You might or might not elect to do a join between your new form and the Product Catalog.

     

    You have to decide if you want one row per selected item x user, or if you want a single row per user with the keys to the Product Catalog.

     

    Such a key field might contain the Request ID field with ; in between of all the selected records, and then you can have the following criteria of your two tables that shows records from the Product Catalog:

    Not selected table (NOT $SelectedProducts$ LIKE "%;" + '1' + ";%")

    Selected table ($SelectedProducts$ LIKE "%;" + '1' + ";%")

     

    The SelectedProducts could for example contain ";0000123;0000987;0000388;" if three rows were selected.

     

            Best Regards - Misi, RRR AB, http://rrr.se