Hello, I need help to do the following:
I created a table for “Comments” for user of the app to add note.
Column headers are: ID (unique), Note, Initials, TimeStamp, Staff Response.
When the user add a comment to the “Comment” form from the app, the note populates correctly on Google Sheet.
Staff adds response (i.e. Done, Pending…) in the ‘staffresponse’ column’ but does not show as a separate row in the app.
The user add another note, that note shows a separate row in the app.
How can I have Appsheet to show user and staff note separately?