I am using the API and GenResultsTable to return a js file. Some of the fields were lookup fields that were returning blank strings. I then created native versions of those fields using a formula field that referred to the lookup fields.
Of the four fields, one of them now pulls the correct data through, but the others are still returning a blank string. The only difference that I can think of is that in the original lookup fields, the field that is now working is a single line of text in its home table and the ones that are not working are multi-line fields.
Does anyone have any insight into how to make this work?