They’re the primary fields of each table, which are indeed single line text. My problem isn’t so much making them empty fields (I just manually create a new record then type a dash because I don’t want to see “unnamed record” in the first table). What I want to do is create these new empty records (with a dash) automatically.
Table 1 is a list of topics of articles. The other 12 tables contain the list of articles published on my website for 12 different countries - about the topics in table 1. When I come up with a new topic, the articles haven’t been written yet, but I’d like to see the topic in the country table (so I know it must be written.) That’s why I need to create that empty record.
To help you understand, I’m attaching screenshots of the topics table and of a country table. You’ll see in the first one that “Cuisine” in Germany has no article, so there’s a dash in the corresponding field. Then you’ll see the corresponding article (or lack thereof!) in the second table (the Germany table).
What I’d like to do is this:
When I think of a new topic, I add it to the topics table. Instead of having to manually create these 12 empty records in the other tables (which I do by clicking the + button and then “add new record” from the topics table), I would like to have a zap automatically make them for me.
My attempt at a zap is triggered by the creation of a new record in the topics table. But instead of filling out the fields in that row, the zap creates a new blank record. I think I am just not so great at zaps
I hope my explanation was clear!