This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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:
Bobs Carpet Mart
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:
Business Name, Rent
DMA, Company Type
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.