Hi there, I have a button that’s meant to duplicate a row in a table and share it with a person that’s selected in a “Share with” column. The formula attached to the button transfers a person’s name from a “Share with” column in the first column to a “Shared” column in the new row:
runactions(Ideas.addrow(Ideas.Idea,thisRow.Idea,Ideas.Image,thisRow.Image,Ideas.Tags,thisRow.Tags,Ideas.Source,thisRow.Source,Ideas.[Disco owner],thisRow.[Share with], Ideas.[Share with],""),thisRow.ModifyRows(Ideas.Viewers,thisRow.[Share with]),thisRow.ModifyRows(Ideas.[Share with],""))
Currently, the button formula overwrites the person value in the “Shared” column if the row has already been shared. But I would like to share it with additional people so that multiple people appear in the “Shared” column (rather than overwriting what’s there). Any idea how to tweak this formula (or column setting) so that I don’t overwrite the individual in the “Shared” column, and instead add additional people?