Can't Save Show If Formulas!?!?!

I was wondering why the show if formula I put on some columns weren’t there… then I tried adding them again, only to find they aren’t saving.

I can confirm that this is true, becuase in the process of making that screen recording I went though that same process about 4 times… each time the formula is NOT saved. :frowning:

@Aleksi


Seems limited to this one app.

One quick thing did you try adding this formula through clicking the edit on the left of the column name and then adding it?
image

1 Like

Negative, I used the ability to edit the show if formula “inline” - not sure how to call that.


Just tried it though… same thing. :frowning:

Tried to add show ifs to other columns in the same table and different tables?

1 Like

Good call… it seems it’s limited to that table. Weird… :thinking:

Try to regenerate the structure.

Seems its limited to these specific columns. @Adam you might wanna know about this…

When I was adding these column in question, they are derivative columns based on others in the same table.
When I was creating them, the system (meaning the editor) automatically copied the show-if formula that I had on the originating column onto the new derivative - which was awesome!
That was exactly what I was gonna do anyways… yet when I saved, the changes weren’t saved.

Now it seems I can’t make any modifications to those column show if formulas.

I just thought I would point out the auto-formula import - I’m assuming that was some “intelligence” of the platform seeing a repetitive task, that someone at AppSheet setup an automation for to cut steps out.

Okay… so I can turn the visibility off/on - but I can’t add a formula.

I’ve encountered something similar to this before as well but for the editable formula on a virtual column which does nothing. Was very annoying.

1 Like

Amen. :pray:

And my clients wonder why I never seem to make any progress on projects… always in a prepetual state of waiting for the exterminators (so to speak).

I’ve sent in like 10 reports a month to the exterminators for a while now. Some small some devastating. Generally they’re fast to the job.

1 Like

Thankfully, they’ve always been really quick to fix things. :nerd_face: Quite unprecedentedly, as well.

I would like to point out that these columns are List columns - there seems to be a pervasive bug with show if formulas and list column types right now.

1 Like

To be fair, the type of people most of us are… they can never anticipate everything we throw at them, either.

1 Like

Man… 11 days I posted this. Just circled round to working on this app again, ran right into the same problem.

wtf.

1 Like