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