When I first set up my base, I established one field, mistakenly, as single line text instead of a number. I recognized it with 100+ records in, and have lived with it ever since. Now I want to change the field type for this field from single line te...
I’m a Plus member, so don’t have blocks, so don’t have the Dedupe block.
I have two linked fields, Brand and Model, and now that I’ve gotten to some scrubbing, have discovered that several of the models and brands are duplicated, or one is misspelled...
Still a newbie, learning steadily. But now that I have 700 records, each with 10 or so fields, including 5 or 6 linked fields, I am mystified to how to update any one field in any one record. For instance, since my base is my records and inventory...
I have 90+ distinct, linked Brands. My Brands table has three duplicates of one brand, each with numerous records attached to them. The duplicates are all spelled correctly, and the same. How do I move records from the duplicates to one, to elimin...
I’m just getting started, and had one bust of an attempt, so now want to ask about the best way to start before I have a second bust. I restore and sell vintage fountain pens, am looking to move to AT from several Google Sheets, and a ton of duplicat...
With thanks in advance, Claudio’s help got me on the best path two years ago. I’ve now lived with my base for two+ years, want to do some cleanup.
The base is an array of fountain pens, with linked bases called “master”, “brand”, and “model”.
A numbe...
Claudio,
Many many thanks… I read the articles. Have kept Brand and Model as linked fields, but changed Status and Country to Single Select. It’s pretty clear that if I were building this from scratch I would have set up a true many:many base, to m...
I’ve found the articles about relationships and how they play out in AT. Think I need to read those carefully and have them guide me. Think I went too quickly into linking when other relationship types might have worked better.
