I've been tasked with creating a custom app that tracks incidents and vendors for construction projects.
Is there a way to link the spreadsheet of current construction projects and a spreadsheet of vendors to an extended task table, so that I can auto-populate reference fields from the spreadsheets to the task table? such as project manager, address, and vendor?
