Hi there! Totally new to Coda… apologies if this has been asked before (I looked and could not find anything )
I have a table of contacts. My client wants to be able to load in a CSV. The CSV has the First and Last name in one field, and my contacts table does not.
I built a table view “Import New Students” to allow for him to copy and paste the CSV, and added two formula fields that split the first and last name up: [First Name (Import)] and [Last Name (Import)]. I want to finish it off with a button that takes the value of [First Name (Import)] for each row of “Import New Students” and inserts it into [First Name] (and same for the Last Name fields).
No matter what I do, I can’t get this to work. I end up with a list of everyone’s first name in the [First Name] field. How can I limit this to only the value of each row at a time?