Adding information to a cell without erasing the data

Ask for Help
1

Hello guys!

I would like to use a text field in a form to add data to a row without replacing or erasing what’s already there.

I want to use it as a comment field, so that users can add new comments while still having the old information there.

Anyone knows if it is possible?

Thanks!

2

This requires a bit of trickery. First, let me ask, is a form the correct mechanism? Forms add new rows of data, but it sounds like you want to just add onto existing data. Is the appended text the only field you’re modifying or do you need additional info such as author, timestamp, etc.?

1 Like
3

Hello @Robert_Petitto , sorry for the mistake, I was planning to use it as a text field in an edit page related to the row. I would also like to add the timestamp and the name of the editor.

4

You can add or remove as many components as you wand from the Edit Form. If all you want is a text entry component for comments, then you can remove all other components from the Edit screen.

The Edit form also allows you to add special value components. That includes the email of the signed in user and a timestamp. Just add those two special value components and set them to write to whichever columns you would like to hold the timestamp and email of the editor.

5

I think he wants to use the edit screen to APPEND new comments to existing comments.

2 Likes
6

Ah, makes sense.

In that case:

  • I would probably add a user specific column to the table to temporarily hold the the user’s new comment.
  • Then add a template column to join the existing comments and the new user specific comment.
  • Then add a button to the screen with a custom action to first clear the user specific column, followed by a Show New Screen → This Item action, to get a second detail screen.
  • Then add a text entry component that points to the user specific column. This is where the user would enter their comments.
  • Then add a button to that screen with a set column action that overwrites the existing comments with the template column comments. At the same time set the datetime and email using the datetime and user email special values.
3 Likes
7

Exactly, that’s right,

1 Like