I have a google sheet tied to a google data studio visualization. I created a google form to allow for the people viewing the data to update it.
This creates another sheet that I use alteryx to overwrite the source document. Works very nicely for my needs.
Recently though I have had a request to put a "comment field" that allows for them to comment on issues and to allow for an automated row update of what was updated through the forms.
I basically need a workflow that looks at the google forms sheet, find which fields have been updated, concate the field names to a single cell, I can then add this as an output to the "comments" form (google sheet)
Examples as follows:
From the update data form:
| Timestamp | Email address | Site ID | DMA | Business name | Company Type | Rent | Phone |
| 6/25/2020 5:46:09 | thisis@test.com | 0005 | | Bobs Carpet Mart | | $1500 | |
| 6/25/2020 6:46:09 | thisis@test.com | 0056 | 114 | | Commercial | | |
Each row is an update to the data, not all fields are required for update and a workflow already takes care of adding the needed fields (from column 3 on)
The comment sheet needs to have:
| TimeStamp | Comments | Email address | Site ID |
| 6/25/2020 5:46:09 | Business Name, Rent | thisis@test.com | 0005 |
| 6/25/2020 6:46:09 | DMA, Company Type | thisis@test.com | 0056 |
That way at a glance the team member can see when an update was done, by who, and what fields were updated
I've tried the summarize and concatenate blank fields, this works to show what is not blank over the whole data pull but doesn't separate each row just makes a count of each field.
