Use "Tables: update a row" with multi-line text

Options
Tom_944137
Tom_944137 Posts: 40
in Questions

I'd like to update a row with multiline text.
The column I'm updated is created using a "Tables: add a column" action, so I'm not able to specify "Long Text" type.
Therefore, when I try to update this column for a given row, the multiline text renders as one line only.

What is the best way to create a column and then update it with multiline values?

Answers

  • Kalin_996882
    Kalin_996882 Posts: 74 admin
    Options

    Hi @Tom_855096,

    Thank you for your question and apologies for the delay in getting back to you.

    When you add a new column to a table, it should be added as a Long Text type field by default. From there, you can use the Tables: Update a row to update the new column with your multiline value.

    One thing to note is that you will need to wrap your multiline text field with double quotes. If you do not do this the value will cut off from the first line. I’ve performed a couple tests to demonstrate this and use a Tables: Look up data to confirm the field value added to the table -

    Let me know if this helps and if you have any questions.

    Thank you,
    Kalin

Categories