What is wrong with my IF formula?

[Naff]

Could you please help me to improve the formula in Auto Compute - Initial value:

IF(AND([POS?]="NAKİT", [DOVIZ]="$"), [TOPLAM $], 0)

I can't get the value from column [TOPLAM $]. It shows zero all the way. I got it actually a pair of hours ago, but then something changed, and I can't get it again 😞 Please help me...

[SkrOYC]

Obvious question, are you sure that the first condition is satisfied?

Your expression doesn't look bad, apart from the usage of some special characters that I avoid completely on column names. I suggest you to stick to the english alphabet

Show More

IF(
  AND(
    [POS?]="NAKİT",
    [DOVIZ]="$"
  ),
  [TOPLAM $],
  0
)

[Joseph_Seddik]

I've worked on apps using non-latin alphabet (not only non-English) and question marks in column names and they function correctly. I think the values of the column need to be checked to see whether there's really a "NAKİT" value. 

[SkrOYC]

What I was trying to say is that the fact that it works doesn't necessarily means you should do it.

It's a best practice to stick to english alphabet, as with any programming language for example.

[Joseph_Seddik]

I totally agree and you are totally right !!! and I don't do that when I'm the original creator. Even spaces should better be avoided. 

Just wanted to share what I've seen. 

[SkrOYC]

Sure! Btw, I'm still on the process of understanding the best naming convention for many things inside AppSheet. I'm gravitating around UpperCamelCase for table names and not sure about column names, maybe lowerCamelCase or with_underscores

I'm studing Dart and I think that making a parallel with programming languages in general is very helpful. Like treating Tables as Classes and Rows as Objets for example

[dbaum]

I encourage you to consider posting a Tip/Trick with whatever conventions you end up determining for yourself. That type of guide based on experience would have helped me a lot when I started using AppSheet.

For example, while I'm certainly very familiar from other work with the benefit/need of techniques like avoiding spaces, when I saw "no code" I figured that shouldn't be an issue here and thought I'd save myself the trouble of entering a display name for every single column. Of course, I now realize that even in this "no code" platform dealing with spaces is inefficient.

Like others, I'm sure, I've also gone through lots of trial and error in determining naming conventions for actions, format rules, multiple levels of automation components, etc.

[Joseph_Seddik]

I guess @SkrOYC and I were rather discussing best practices in general, though as far as AppSheet is concerned, column names, table names, action names, etc. accommodate for spaces perfectly. Even official guides and help documents contain spaces in column names, the system-generated reverse-reference column "Related something" contains a space. 

The complications I could think of would be for example for when generating URLs and when dealing with external systems in general. So yes, it is generally better to avoid spaces, accentuated and special characters.

[dbaum]

Yes, I understood. I was referencing, for example, that even though AppSheet certainly handles spaces in table/slice/column names really well (and way better than Power Apps!), it's a handy tip to know that it can nonetheless be more efficient for an app creator to avoid spaces in order to leverage code completion functionality like that provided by the AppSheetTraining.com extension.

Even more impactful would be tips regarding naming schemes for actions. For example, I see from MultiTech's videos he clearly has a robust system of icons, delimiters, and other conventions that help him. I haven't checked, but he may have even shared his conventions somewhere, perhaps for his Patreon subscribers.

[Naff]

It seems that the formula really can't see [POS?]="NAKİT" and [DOVIZ]="$". What can be wrong here?

The column data type of  [DOVIZ] is ENUM. Base type - "Text"

The column POS$ is type Yes/No

[Naff]

I put this formula IF(AND([POS?]="NAKİT", [DOVIZ]="$"), [TOPLAM $], 0) into the Auto Complete - İnitial value, because I need to be able to change the result if necessary.

[Joseph_Seddik]

The values you put in a Yes/No column are for display only. Your formula should be:

IF( AND( NOT([POS?]), [DOVIZ]="$" ), [TOPLAM $], 0 )

[Joseph_Seddik]

@SkrOYC Thanks much my friend. This Dart looks like a beautiful C. It is the latest addition to the list of things I know about from you 🙂

I just use lowerCamelCase for everything, almost.