Is it possible to append a value to a column rather than clear the existing value and then replace it with a new value?
I am creating a jobs app where employers post jobs and jobseekers apply for a job.
I have a Jobs sheet which contains a list of jobs. When a job seeker views a job, the job seeker can apply for the job by clicking a button. I have a column Applications in the Jobs sheet which I would like to use to collect all emails of users who have applied for a job.
Is there a way to add an email to the column which would have other emails as well? If I use Set columns, it only adds each users email after replacing the existing value. Any option to keep adding emails to the column?