Copy Entire Row

[Qiro]

I'm looking for an elegant and efficient way to copy an entire row (new or updated) to a new line in another table.

This is obviously for auditing purposes and my current method utilises a bot and a long concatenated expression that I have to tailor to each sheet.

CONCAT([Col1],[Col2]...)

It works, but is hardly efficient. Is there a better way?

[diogolupcosta]

There is an event in actions Just for It bro

[Aurelien]

Hi @Qiro 

As @diogolupcosta said, this is this one:

For what you describe (new/add or update) you may not even need a bot.

Just specify which action you wish to fire on form saving:

[Qiro]

Hi @Aurelien

This is the method I'm using now, though it only occurred to me that I could do it as a save action without the bot, after I'd gone to bed!

I am trying to add all the data to one cell, because the tables I'm copying data from are all different. That's why I was concatenating the data.

Am I already doing it the best way?

[Aurelien · Accepted solution]

@Qiro in this case yes, this is the best way 🙂

[Qiro]

Thanks for confirming.

Just for the sake of tidiness, I have separated each data point with "," to create comma separated values, but where there is no data, you end up with a string of commas. 

Am I right in thinking complicating the expression with IFS might slow things down? This is the kind of thing I'm outputting right now. 

NAME,DATE,TIME,,,,,LOCATION,COLOUR,,,TEMP,

Any suggestions to keep it clean?

[Aurelien]

I think it is a good way to deal with it, in my opinion that won't slow it too much 

You can also try this:

CONCATENATE(
  LIST([Col1],[Col2],...,[ColN])
  -LIST("")
)