I believe there may have been a problem with Airtable itself, as I went to confirm which columns I had and which were or were not populating and got a whole new set up from Airtable (last time I was working on automations it all remained in the right side bar, now it is full screen.) Re-testing my automations resulted in the grids populating correctly, as opposed to missing data and columns. I have answered questions and/or responded to everyone below just in case they wanted their questions answered, but I currently consider the problem solved.
Thanks again everyone for the help. It was really appreciated.
@Dominik_Bosnjak: I’m not sure where I would put that formula? As a formula column to see if I can get the information that way? I’m probably still going to keep the formula, as I can already see use cases for it with the stuff I am working on, but I don’t think that will work with this problem, as I tried a couple different ways to get the column to populate, including several formula columns. No dice at the time of the original post.
@Justin_Barrett: That is correct. The grid in the email does not include actual data from the record, but that statement is true for only some columns. These columns would have been populated long before it entered into the view, so I don’t think that is it either.
The filter has two parts (the second not being enabled yet, otherwise the tests would fail)
- Filter by order type to include specific types
- Filter by order date, where order date is 14 days from now.