I have been scratching my head over this one and could use a nudge in the right direction. The simplified use case is: Table A has 1000 records. Field 1 = Category Field 2 = Label There are 100 categories hence 100 sets of 10 ‘Labels’ each. Some of the ‘Labels’ feature in multiple categories … …

Why are the field names needing to change in Table B? I’m not sure I understand that. Instead I’d make a form in Fillout and just Display the question differently and write to the same fields. That will get you a cleaner result. Then just load in the field names via url parameters that you can pull…

[image] Michael: the goal is to transpose a record from Table A into a field name in Table B. I get it, but that’s a bad goal. :wink: You need a new goal - like make one [virtualized] form that acts like a hundred different forms.

@joshsorenson - thank you! This is ideal. I see that I was unnecessarily overcomplicating a simple problem. The URL parameters do the trick nicely.

Hi @bfrench - yes, that sounds like a far better goal. I suspect that it’s beyond my scope for the time being.

Transpose data from records to fields

Airtable Questions

joshsorenson June 22, 2023, 2:09pm 6

What I described on fillout.com will achieve that very easily.

Topic		Replies	Views
Airtable Forms- multiple records update Airtable Questions	13	456	February 18, 2023
Add many fields in bulk to existing table Airtable Questions	4	349	March 14, 2023
Fillout forms and airtable - updating multiple tables Forms, Views, and Interfaces	4	304	March 11, 2025
List your top Airtable feature requests here! News & Announcements	146	4888	October 1, 2025
Introducing Airlift External Apps	18	556	February 2, 2024

Transpose data from records to fields

Related topics