How to autogenerate a row after filling Data in a form?
We have a form that is being summited daily, and creates a row for each day. Some fields have the same input example Activity Name, Reference Number and so on that are specific for each person filling the form. The aim is to have the form filled the first time, and the next day only request updates on specific fields. The issue is that we do not want to update the same row or overwrite the cells, yet what it is needed is to create a new entry with the fields that are not required to be updated already filled with the data from past entries on the same sheet.
Please need help on this can be possible. And better to have a solution based on what SmartSheets Offers maybe an add on could work.