I’m moving a CMS over from AirTable (and Filemaker) to Coda, and I’m running into really basic things that I can’t find an answer to.
Today, how to create live links between tables.
So I have a table of names with two columns – Contact Name, Company Name.
And a second table, of company names: Company Name, Address
I’m looking at my contacts table, and I’d like to have a button on each row that if I press it, it takes me to the Company page (or view or table, I’m still having trouble getting these straight in my head).
Like a hyperlink, but to another view in the same database, not out on the web.
AirTable populates these automatically when you have related tables.
My second questions is, if I don’t have a company yet for a person – if that field is blank – I’d like to be able to choose a company name from the list of companies in the Company table, and then have it turn into a live button once chosen.
Or does the drop-down selection list, and the button, have to be two separate columns?
And ideally, I’d like this to be an option for multi-choice fields as well.
So for, example, in the Company name, there would be a column “Contacts” and under that a list of all the people at the company. Since there could be several contacts at a company, some of those cells will have several names in them, and I’d like each one to be a separate, live, link button.
Is that possible?
(Again, AirTable does this automatically.)