Hi, I’m trying to build a process that updates data that changes over time. If I was doing this manually, I would add a new column and import the records into their cells. From a monthly update I want my process to create the new records that show the new values. I’m able to create a relationship to the record but it becomes a challenge when I want to add a new column that shows the new records. Make can add new Rows in a Google Sheet or Airtable, but not a new Column (why not??). I’ve found some ways around this but wonder if there’s just a better data store where I might be able to accomplish this. I don’t really care if there’s a database system where I can dynamically add columns and populate the data updates. Any suggestions would be appreciated!
Thanks,
Craig