Answers

• colin Posts: 15,240Questions: 1Answers: 2,599

  September 2023

  row.add() is used to add a row to the table in the DOM, it won't be reflected in the backend data - so a page refresh would just remove it.

  Instead of row.add(), you'll need to use the Editor API instead to create (create()) the record, you would then set the field values (set()), and then submit (submit()) the record back to the server.

  The code you've got in your first block is very similar, it just needs those different methods.

  Colin
• pmarks906d Posts: 61Questions: 18Answers: 0

  September 2023

  Thanks Colin. I am having trouble finding the syntax for the "editor.create()", "editor.set()" and "editor.submit()" javascript commands. could you give me a quick example of what the code should look like?
• pmarks906d Posts: 61Questions: 18Answers: 0

  September 2023

  The following may be the syntax; but I haven't managed to add a row with it yet.

  editor2.create(false).set({
              "dp-25": "pmarks906d@aol.com", // cust email            
              "dp-50":  "Saved", // to/from cust
                ........ etc ..............
              "dp-76": 5000.00,  // total cost 
            },).submit();         
  
• colin Posts: 15,240Questions: 1Answers: 2,599

  September 2023

  It seems the issue is that it doesn't like all the fields grouped together. I'm not sure why. I've raised it internally (CT-1603 for my reference) and we'll report back here when there's an update.

  As a workaround, you can list the fields individually, like this (example here):

      editor
        .create(false)
        .set('dp-288', new Date().toString())
        .set('dp-289', 123)
        .submit()
  

  Colin
• pmarks906d Posts: 61Questions: 18Answers: 0

  September 2023

  Hi again. So I've got the code ready to go shown following. When I hit the button it executes with no console errors, but nothing is added to the table. What am I missing?

      editEmailButton2Element = document.getElementById("editEmailButton2Id"); 
          $('#editEmailButton2Id').on( 'click', function () {
            console.log("Adding row");           
            editor2
              .create(false)
              .set('dp-25', "pmarks906d@aol.com") //email2Element.innerHTML,// cust email            
              .set('dp-50', "Saved") // to/from cust              
              .set('dp-26', "phil marks") // ull name
              .set('dp-24', 00200) //  email id (sequence, unique, positive integer)
              .set('dp-86', "" ) //new Date().toString()) // (date time required)
              .set('dp-29', null) // image (deault empty)
              .set('dp-30', "Painting") //artworkTitle2Element.innerHTML, // art img name
              .set('dp-51', 00101) //artIdElement.innerHTML, // art id #
              .set('dp-34',"") //imageUrlElement.innerHTML,//img url(must url default empty)
              .set('dp-35', "2x2") //titleSize2Element.innerHTML, // orig size
              .set('dp-78', 20.00) //titlePrice2Element.innerHTML, // orig price            
              .set('dp-38', "Avail") //titleAvail2Element.innerHTML,//orig available
              .set('dp-53', "Gen") //radio2Element.innerHTML, // reason
              .set('dp-85', "yes") //titleBuy2Element.innerHTML, // buy original
              .set('dp-39', "1x1") //print1Size2Element.innerHTML, // print1 size
              .set('dp-79', 5.00)//print1Price2Element.innerHTML, // print1 price
              .set('dp-55', 10) //print1Qty2Element.innerHTML, // print1 qty
              .set('dp-41', "3x3") //print2Size2Element.innerHTML, // print2 size
              .set('dp-80', 5.00)//print2Price2Element.innerHTML,//print2 price
              .set('dp-56', 2) //print2Qty2Element.innerHTML, // print2 qty
              .set('dp-43', "5x5") //print3Size2Element.innerHTML, // print3 size
              .set('dp-81', 9.00)//print3Price2Element.innerHTML,//print3 price   
              .set('dp-57', 3) //print3Qty2Element.innerHTML, // print3 qty   
              .set('dp-45', "6x6") //print4Size2Element.innerHTML, // print4 size   
              .set('dp-82', 7.00)//print4Price2Element.innerHTML,//print4 price   
              .set('dp-58', 1) //print4Qty2Element.innerHTML, // print4 qty  
              .set('dp-47', "2x2") //print5Size2Element.innerHTML, // print5 size   
              .set('dp-83', 3.00)//print5Price2Element.innerHTML,//print5 price   
              .set('dp-59', 90) //print5Qty2Element.innerHTML, // print5 qty              
              .set('dp-60', "from cust") //msgFromCustomer2Element.innerHTML,   
              .set('dp-61', "to cust")//msgToCustomer2Element.innerHTML,//msg to customer   
              .set('dp-62', "phil") //firstName2Element.innerHTML, // 1st name   
              .set('dp-63', "marks") //lastName2Element.innerHTML, // last name   
              .set('dp-64', "1582 rd") //address12Element.innerHTML, // address1   
              .set('dp-65', "apt 3") //address22Element.innerHTML, // address2   
              .set('dp-66', "pb") //city2Element.innerHTML, // city   
              .set('dp-67', "fl") //state2Element.innerHTML, // state   
              .set('dp-68', "usa") //country2Element.innerHTML, // country   
              .set('dp-84', 32909) //zip2Element.innerHTML, // zip   
              .set('dp-70', 2.00) //buyOrigShipping2Element.innerHTML, // master shipping   
              .set('dp-71', 1.00) //print1Shipping2Element.innerHTML, // print 1 shipping   
              .set('dp-72', 1.00) //print2Shipping2Element.innerHTML, // print 2 shipping   
              .set('dp-73', 1.00) //print3Shipping2Element.innerHTML, // print 3 shipping   
              .set('dp-74', 1.00) //print4Shipping2Element.innerHTML, // print 4 shipping   
              .set('dp-75', 4.00) //print5Shipping2Element.innerHTML, // print 5 shipping   
              .set('dp-76', 5000.00) //totalCostWithShipping2Element.innerHTML // total cost 
              .submit();                  
            console.log("Added row");             
          });
          console.log("here");
  
• allan Posts: 63,464Questions: 1Answers: 10,466 Site admin

  September 2023 Answer ✓

  Hi,

  Are you able to PM me a link to the page showing the issue so I can take a look? There isn't an obvious issue there.

  Allan
• pmarks906d Posts: 61Questions: 18Answers: 0

  September 2023

  Here is a syntax which works (Thanks allan amd colin):

            let newDat = new Date();
            editor
              .create(false)
              .set('dp-25', 'pmarks906d@aol.com') // customer email            
              .set('dp-50', 'To Customer') // to/from the customer              
              .set('dp-26', 'Phil Marks') // full name  
              .set('dp-24', '00200') // email id 
              .set('dp-86', newDat) // (date time)
              .set('dp-29', null) // image
                     ................ etc ....................
              .set('dp-75', '4.00')  // print 5 shipping   
              .set('dp-76', '5000.00')  // total cost 
              .submit(); 
  

  Note that datatable fields defined as numbers are passed to the set command as strings. Also datatable fields defined as date-time are passed in as the direct result of a newly defined date. The image being passed in here is just a null, because I am still trying to figure out a way to pass in an uploaded img file. The email id field is a unique sequence type, whose dummy value gets replaced automatically with the number next in sequence (starting at 0 and always increasing by 1.
• allan Posts: 63,464Questions: 1Answers: 10,466 Site admin

  September 2023

  Awesome thanks. Good to hear you got it working.

  I should note that I never really anticipated CloudTable's Editor being used quite this way. I don't think it will cause any issues going forward, but my preference would be for the REST API to be used rather than Editor directly (just in case I ever change anything in how CloudTables).

  Regards,
  Allan