Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Let & List in calc

Featured Replies

Here in an interesting thing I found today. I have attached a sample file. I have used a list () on some let variables in a calc.

This behavior could possibly be associated with this recent thread but I dont think directly.

http://fmforums.com/forum/showtopic.php?tid/186557

List_Test.zip

What's should we be looking for?

  • Author

Sorry Mike. I thought that the example would explain it.

The list () returns a value of 0 if a flag boolean field is zero where a test is made as such: Case ( flg_car; "Car" ).

It will return

House

0

Job

However if Case ( GetAsBoolean ( flg_car ); "Car" ) is used, then it returns null.

House

Job

So I tested it as a concat thinking that the let was passing the value zero. However, it returns null, as the concat returns "HouseJob".

So why does using the list function return a zero instead of the null when GetAsBoolean is not used?

It looks like a bug to me. The variable should be empty, and probably classified as Text. Note that the problem goes away if the variable is expressly defined as Text.

I am guessing something in the order of evaluation causes the variable to be forced into a number, under these particular circumstances.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.