So, I have created my first app in Honeycode and I only have one significant issue. I have two columns in my projects table with Filters that reference my task table and my formula works in the table view.
When I use my app to add a row to the project table the two filter columns return "#NAME?" instead of the filter.
I went to the "Done" button on my app and updated the automation with my filter formula from the table view pointed the formula at the proper column and selected the "Write as Formula" Option and I still get "#NAME?" in my table. I tried deleting the two formulas from the automation and I get "#Name?"
I tried putting quotes around the entire formula and writing it as a value.
The only way I have had success was to write an automation that looks at the projects table filtered columns overwrites the "#Name?" with the working formula.
Is there some change I need to make to my formula for the app automation to work?