Append a value to a column

Ask for Help
10

Wanted to add to this thread as it was helpful in creating an append column in a slightly different way.

Problem: I wanted to create a form where a response would append to a particular column rather than create a new row or be added to a seperate column. All within Glide because I like Glide :slight_smile: .

Solution:

To append these values I first set the following User Specific Columns

  1. A column to store text to be added when a response is submitted. (Text Add)
  2. A column to store text that would store all of the text from collected responses. (All Text)
  3. A column to store the text that the Text Add values would be appended to. (Append Text)

Then used a custom action to:

  1. Set Append Text with the value in All Text
  2. Then clear the value in Text Add so that it would be available for next use

To append text the “Append Array” function column was used. To facilitate the adds an array column was created with the value of Text Add using a lookup column. Then an array was created to house the value Append Text. Then the Append Array function column was used to append the value of Text Add to Append Text.

Afterwards made a few changes for formatting and boom! A form submission that appends values to a User Specific column, which can then be saved to data a la custom form functionality. How do I create a custom form?

2 Likes