![]() We are left with the merged, new “Name” Column. So create one using Apps Script and then add a link to the document in the 3rd column. If it is empty, it means a Google Doc does not exist yet. For each row in the sheet, check if the 3rd column is empty. Now you can delete the FirstName and LastName columns and the original Name Column. The script to automate creating Google Docs will work in the following way: Load the data in the spreadsheet. First, Copy the Name Column :Ĭreate a new column and do “Paste Values only”. You have to first convert the “Name” column to values. This is because the Name Column is constructed using those first two columns. You may want to delete the FirstName and LastName columns (the source columns) However, then the Name field also will become empty.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |