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
              sg NameToUpdate

              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