Data table - Copy data from to

Options

Hello Community,
I try to realize a java script in Catalytic.
I have a data table like the example in picture.
I need a java script if the values in in one row are missing they must be copied from one line above
I want to realize it with the Action Apply Formula to Columns.
Thanks for help!!

Answers

  • Sean_510793
    Sean_510793 Posts: 69 admin
    Options

    Hi @Nick_779929, I do not think Apply Formula to Column will work for this situation. Iterating/batching wouldn’t be guaranteed to work either because sequence is not ensured. It would take a bit of code but I think this could be done via afield formula.