Apologies these are probably quite dumb questions, but I’m not a programmer and not overly tech savvy.
I work in film and in production we complete a range of repetitive tasks.
-I’m hoping to build a doc that uses a database/table to draw information to enable autocomplete in another document.
-The data would be crew details, that won’t login to or use Coda.
-The data would be their name/phone/email and perhaps other line entries.
-Part of this would be how do you connect information in the same row but in different columns, for instance, name, email and phone number. You start inputting a name and a contact comes up, once you select, the name is completed, and phone/email cells are auto completed as well in cells in the same row.
Any suggestions/thoughts or ideas would be greatly appreciated.
All the best,