Hi Folks - Somewhat new to Airtable but have done deep dive and feel pretty good about how things work.
I am developing a grant application processing Base that is pretty complicated. One of the necessary evils is long primary fields. Like 25-50 chars. We maybe be able to trim them in the future, but becuse the primary field is so important in Airtable (ie, card headers, text that displays for linked field values, etc etc), it has to be real and not a numerical code etc. My main primary field is like this: 2020-059 - ABC - Smith Tract - Big River State Park.
It has been creating all types of issues on import, commas were an issue until I killed them (easy fix) and then creation of “quotation marks” around primary link fields in other tables as I turn primary key links on and off in working on getting the base made.
ANYWAY - i had a corruption issue occur where additional spaces got inserted in the primary field, evidently where the key got wrapped in a given view, and then it stuck. see below if you are curious about that or have ideas on how to avoid.
Advice on characters to avoid? Commas obviously. Dashes vs " | " marks? Underscore would be way less readable but I may have to try it… I need to make sure this is somewhat bombproof when I role out to 9 staff and we all put our annual work cycle on top of it without alternative methodology in place…
Should I auto-populate the primary field with the three components? How would this work with importing/linking additional tables (ie, a many to one budget line table that is initially a large import?)
Thanks!!!
Damon
PS - Airtable has no bug or error report category in contacting help. I submitted it under Other Questions or something. Am I missing something or do they really not have an official way to report an issue? I guess most reports are operator error… but hmmmm.
Hello - I’ve had an issue where a longish primary field has been corrupted at a point where something has apparently inserted a carriage return that comes out as three blank spaces in the data. This is where the primary field got wrapped in a certain view? See screenshots. First one is the data with carriage return (that I did not insert, I don’t even know how haha) showing that the data wont return to one line even when there is room. second screen shot showing the three spaces that I didn’t put there… Causing a major issue with data importing and auto field linking. some of the issue spots I am seeing are only one extra space, I am now seeing… I’ll try to fix with a cut and past out to excel or a find and replace script run. But I have to use long primary fields, so any help to avoid is appreciated. Thanks, Damon Hearne
