Formulas Breaking with new Table Rows

[aidendj13]

Hi all! I'm pretty new to tables and formulas so I might be doing something wrong. I have a few formulas set up in my table and they work well when I manipulate the table directly in the table editor, but when I create a new table row through my app the formulas all return a #NAME? error.

Any help would be much appreciated. Thanks!

[AndrewB]

Hi @aidendj13 !

We'll probably need some screenshots to be able to help, but some things to checkout:

Data Cells

About data cells Data cells are objects in Builder that you can use to show data from a table, either as a direct reference or from an expression. What’s more, data cells are super customizable and give you flexibility to: Allow app users to edit data Use data cells as variables Display data based on a condition Use data cells in automations Choose how to format your data cells Make data cells editable It’s easy to make data cells editable. In data cell properties, simply select “Editable“ f…

How to Create a List with a Filter

Topic Adding a filter to a column list makes it easy for users to sift through data, so they can see just the information they want. Steps Builder's tip: Please note that these steps assume you already have a table with columns of data. In Builder, click + Add objects and select Column List. [Add a Filter to a Column List in Builder_Image 1] Fill out the fields for List source (the table) and Display (the columns you want shown in the app). Click the checkbox for…

[Sid]

Hi @aidendj13
As Andrew said, we will need some screenshots to be able to help. As a reminder, please do not share any screenshots containing private information.

Other posts that might help:

Triggers & Actions

Summary An automation is a self-operating series of actions that you can configure in Honeycode. Automations can help your team to stay in sync—in real time—and put repetitive, manual tasks on autopilot. A trigger as the name implies, is the condition that starts an automation. An action is the next step executed when a trigger condition is met. Adding automations First, open a workbook. In the left nav, click the [+] next to Automations. [Add automation] Here you’ll see the area where…

How to Build a Form from Scratch

Topic Forms in Honeycode provide an easy way for your users to add and update data in your tables. You can build a form for just about anything from a simple contact form to a detailed survey. The image below shows an example of an Add Task form in a Task Tracker App that we'll be showcasing throughout this article. This form let's users add new tasks to the Tasks table via the app. [Build a Form Screen_Image] This Add Task form is an app screen that allows your teammates to fill out a form …

[aidendj13]

Thanks for the replies! I actually figured out that the problem was that that "Done" automation was writing blank data to those cells. Removing those cells from the automation fixed the problem!

Thanks for your help!