Populate Google Doc with Google Sheet information
Budget: $30 – $250 USD
I deploy employees for daily (temporary) construction work, and each shift goes out with a "ticket" that is a Google Doc that has six fields of information prefilled on it. I have a jobsite spreadsheet that has these data and I need to have a button or link from the spreadsheet that fills in that information for that jobsite. Each day there may be different people going to that job, but often it's the same people. So once the first Doc is created, using the most recent version of that Doc is best practice. This could be accomplished with a "create new doc" (prefills the doc with the information from the spreadsheet) or "use most recent version" (uses the last one that has been manually modified) link.
1.png: Source Data on the Google Sheet
2.png: Blank form populated with source data
3.png: Recurring use of the same information, using latest version with filled-in data
1.png: Source Data on the Google Sheet
2.png: Blank form populated with source data
3.png: Recurring use of the same information, using latest version with filled-in data