Skip to main content
D
darpan13
Newcomer
January 12, 2022

Insert Rows using Spread sheet

  • January 12, 2022
  • 1 reply
  • 0 views

SOURCE: ONESTREAM CHAMPIONS

Hi Friends,

Did anyone try inserting rows into a custom table ( within one stream ) using Spread Sheet?

I am able to update the data into the custom table, but somehow the basic functions like insert didn’t work for me.

I need a similar function as per the screenshot for identifying the new records and the existing records.

 

https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/1c5dee15c2a1bb8d86b5682de4f4220b3122a2bd.png
Expectation in SS.png966×362 20.1 KB

 

Regards and Thanks

Darpan Bhansali

    1 reply

    D
    darpan13Author
    Newcomer
    January 12, 2022

    Any Thoughts to be shared?

    C
    ckattookaran
    Newcomer
    January 12, 2022

    You need to create the spreadsheet rule that allows inserting. You can enable how many insert rows need to be provided as well. I use the status column feature to perform INSERT, UPDATE, and DELETE operations.

    D
    darpan13Author
    Newcomer
    January 12, 2022

    Hi Celvin, thanks… i can understand what you spoke above… but unable to write the code… if possible can you please share the code which you used.

    that will be of great help

    Regards

    Darpan Bhansali

    Terms & ConditionsAccessibility statement