I have a set of data generated from a user survey. For each question I asked them, I am going to score their answer. I have no issues with this when their answer is, for example, “google.” I set up a new table, link the fields from the full set of data to the new table and then put a score of 6 in the next column from google and am all set so that everyone who said google gets a 6. But when I try to do this with more complex data, the new table cuts off most of my text. For example, one cell reads
2: Google Scholar
3: Library Website
But everything but the first line is removed. This also happens with items that are just one long paragraph. Basically anywhere I’d use a long text field type. I can get around it by manually doing a bunch of stuff in Excel but surely there is a more elegant solution?
TIA for any advice! I’m new to Airtable but not to database management :slightly_smiling_face:
I’d like to link the column “Database ranking” to another table. But when I do so, it cuts off everything on the second and following lines. So the cell would just read 1: Google. It does this on any column that would regularly be set to “long text” field type.
Linking in Airtable is on a record base. You cannot link to a specific column. You can link to a record, and then have a lookup or rollup of the specific column.
It may just be a display issue. Normally rows are sized to show only one line of text, even though there may be multiple lines of text in the field. The additional text is there, as you can see in your screen capture. In order to see the additional text you need to expand the cell or record. You can also adjust the row height. Unfortunately there is no way to have rows auto adjust their heights to show all contents.
Thanks for the reply! If I change the field type on the Database ranking column to link to another table and have it create a new table, it definitely cuts off my data. Here’s what that looks like. I even clicked on fields just to make sure that the data wasn’t hiding in the pop up view. So, before it was a linked column, lines 1 and 3 were completely different, but once it’s linked data, they are the same and now my data’s no longer accurate. Again, this happens anytime the data is more than one line long, so it’s a pretty consistent occurrence.
Thank you for the additional information. I didn’t realize that the problem was when you were converting a long text field to a linked record field.
When you convert a field into a linked record field, Airtable has to guess how you want to match up cell values with rows in the linked table.
Are you creating a brand new table when you make the conversion, or are you linking to an existing table? I have better success at field conversions when the linked table already exists and the original text field has comma separated values that exactly match the records in the linked table.