Hi,
I’m importing a Google spreadsheet as a new table in Coda, where I have one column that consists of timecode data in the format 00:10:08 (mins, secs, frames).
When I import this into Coda, it automatically switches this to a time format that includes AM along with the option to choose times at 30min intervals. I can switch the time format so that it displays the timecode properly but I still have the option of a dropdown for 30min intervals which I’d prefer to avoid as it’s going to confuse the client.
Is there any way of getting Coda to view this simply as a plain text number?
The enhance the chances to get a proper solution, I recommend that you create a shared sample doc with the expected outcome and and a source spreadsheet, from where you import.
See the screen recording and at the end you will see that I change the column type from select to text, so the content will be text based as you requested.
Somehow Coda interpretates the values as a select list, but as you see you can update the column type property afterwards.
Hopeful this meets your expectations:
Note: If you want to add more of the same type of data with the same structure, you can add it and then the settings will be straight away correct.
TIP:
Just make a table with 1 row and the two columns as text, then when you import in that table the .CSV data, all will be fine and you could then delete the first row content.
TIP: