# All New Data Editor & Computed Columns **URL:** \ **Category:** General\ **Created:** [November 3, 2021, 12:54pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964 "2021-11-03T12:54:50Z")\ **Posts on this page:** 20\ **Page:** 4
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 5, 2021, 11:34am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/61 "2021-11-05T11:34:30Z")
I think @Mark_Turrell is special 😉 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 5, 2021, 11:53am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/62 "2021-11-05T11:53:10Z")
> [@VVerhille](#): > > should not indicate plural Do you say zero item or zero items??? ---
**Author:** ![Heyhyeok](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heyhyeok/32/33563_2.png) [@Heyhyeok](https://community.glideapps.com/u/Heyhyeok)\ **Post date:** [November 5, 2021, 12:47pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/63 "2021-11-05T12:47:40Z")
wow good!! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 5, 2021, 12:56pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/64 "2021-11-05T12:56:21Z")
I think I argued for this the other day in another thread. I think it should always be 0 items but seems like French people don’t use it that way? ---
**Author:** ![VVerhille](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vverhille/32/16246_2.png) [@VVerhille](https://community.glideapps.com/u/VVerhille)\ **Post date:** [November 5, 2021, 12:59pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/65 "2021-11-05T12:59:17Z")
maybe should indicate the sigular expression. But maybe should say “No item” or in french “Aucun article”. Maybe best approach is to set another field in the plugin just to let the user choose his best “0 expression” ? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 5, 2021, 1:03pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/66 "2021-11-05T13:03:35Z")
Yeah that would make sense to have an additional parameter for zero. While counter-intuitive (as English often is), it’s common to express zero items in it’s plural form, so to me it makes sense how it works now, but I completely understand that it’s not the case in all languages. In English, anything above 0 and less than or equal to 1 is considered singular, including decimals, since it refers to a single item or part of (in the case of a decimal value) a single item. Any number above 1, but also including zero, refer to the whole collection of items. English is weird. I get it. 😉 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 5, 2021, 1:06pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/67 "2021-11-05T13:06:07Z")
or… you can just use an if-then-else column and express singular and plural anyway you like 😉 ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [November 5, 2021, 11:26pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/68 "2021-11-05T23:26:32Z")
How quickly are the updates recognised back in Glide @Mark_Turrell ? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 6, 2021, 3:43am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/69 "2021-11-06T03:43:52Z")
Is it just me or do we no longer need RowIDs for User Specific Columns? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 6, 2021, 4:34am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/70 "2021-11-06T04:34:02Z")
We’ve never needed them in Glide Tables, as far as I’m aware - although I always add one anyway. But we still need them in tables linked to GSheets? ![Screen Shot 2021-11-06 at 12.32.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/cae461b33b0f4d9785f6b77ee801aba97c4776a2.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 6, 2021, 7:03am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/71 "2021-11-06T07:03:51Z")
Can confirm. > [@Set Column Bugs](https://community.glideapps.com/t/set-column-bugs/24730/6): > > You do not need to add a Row ID column with Glide Tables because there is one build into the implementation. Please create a Support case however, by emailing [support@glideapps.com](mailto:support@glideapps.com). I did take a quick look on the outside chance something caught my eye, as did the user-specific column thing, but in order to escalate it to Engineering I would need to have a case started in our system. ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 6, 2021, 7:03pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/72 "2021-11-06T19:03:42Z")
Aïe! Looks like it’s not accurate yet for foreign D/T format. The columns show my Time Zone, not the user’s. Besides, how can I capture user’s Time Zone in Actions (Add Row, Set Column)? I can only select “Current Date/Time” without any other option. Will we get the same options as in Computed Columns for consistency? The screen cap shows the results all relative to my Paris/France Time Zone. Sometimes it says CET, sometimes UTC+2. And it says “Summer Time” instead of “Winter Time” with trouble dealing w/ the european DD/MM/YYYY format (it says June 11 instead of November 6) The “Europe/Paris”(not accurate, BTW) is missing in the last row. Refresh issue. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/2/6228c7b157296302eb0fd1b6c5fa38fb6e155f0f.png) and it can even say “in 2 hours” like a prediction 😄. When the user is in my TZ+2. Funny, but not accurate. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fc761e26b56e4b746d53ded89d7c8c7d2df8d7bb.png) Thks for your insights 🌸 ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 7, 2021, 9:21am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/73 "2021-11-07T09:21:25Z")
I like that. But would be great if I can access any of my app screen/tab, even nth component (link, image, pdf, especially) via a consistent URL format like appname/tab-screenname/componenttype/nth/read&filter= where filter can be a sort, zoom. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/218a97b50beba731ffd4f0df84b2982c41475ab8.png) and provided all our resources (especially logos, backgrounds, attachments can be organized in one single place linked/related/integrated to our app) ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 7, 2021, 9:38am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/74 "2021-11-07T09:38:29Z")
Hum. Makes me think of a “Liar detector device”. Can anyone find a cool use case for IsFalsey? Could help me remember that one fine day. Thks. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/13a97fd1430a2f4b449e881eb78e950897b4d626.png) (Yes, I’ve seen this [Is Falsey column • Glide (glideapps.com)](https://www.glideapps.com/plugins/falsey) and the GitHub as well. But a smart use case would really be cool & cookie for my brain 🍪🧠 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 7, 2021, 10:00am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/75 "2021-11-07T10:00:48Z")
An obvious use case is testing a boolean column. Glide booleans have 3 states: - Empty - False - True An important thing to understand is that `empty` _does not equal_ `false` People often get tripped up by this because they forget (or don’t know) about the empty state and so they start testing `empty` booleans as `false` and their heads explode (metaphorically, of course) when they don’t get the results they expect. Using `IsFalsey` would circumvent this, because a boolean that’s tested for `IsFalsey` would return `true` for both `empty` and `false`. But an easier way is to just avoid testing for `false` altogether, and test for either `is true` or `is not true` (because `empty` and `false` are both `not true`). This method is good for the vast majority of use cases. Have I confused you yet? 😉 There would be similar use cases for other types of columns. ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 7, 2021, 10:07am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/76 "2021-11-07T10:07:16Z")
Actually, I was rather looking for a “real-life use case”, not a “general abstract concept”. Yeah, sometimes, I can be “less philosophy”. Imagine you’re a great National Geographic Channel Genius Speaker (say Jason Silva). What story would you tell me to understand and enjoy this feature? I’m an instructor, I love to find easy & playful use cases. Otherwise, anyone can read a “dictionary definition lesson”. Can you find sth? Like Brain Games of Science of Stupid? ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 7, 2021, 10:19am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/77 "2021-11-07T10:19:39Z")
Love the “kebab text” 😄. Can be useful for string management to insert hyphens. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/e/7e1febd71311ada5a3b9b656337cee06c9b7c805.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 7, 2021, 10:48am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/78 "2021-11-07T10:48:12Z")
> [@L.M](#): > > Imagine you’re a great National Geographic Channel Genius Speaker (say Jason Silva). What story would you tell me to understand and enjoy this feature? Are you asking me to be creative? That would involve using the right half of my brain. I killed that off with alcohol years ago 😛 Anyway, I’ll try. Imagine your app has a welcome screen/tab, which you only want to show to “unregistered” users. The way you tell if a user is registered or not is that you have a boolean column - let’s call it “Is Registered” - in your User Profiles table, and once a user is registered, you have an action that sets that column to true. So you want to set a visibility condition on your welcome tab, so that it only appears for new users. You might be tempted to do something like “where Is Registered is false”, but that wouldn’t work, for the reasons I pointed out earlier. So armed with this shiny new IsFalsey column, what you could do is point that at the “Is Registered” column, and now your visibility condition can be “where IsFalsey is true” - and that will work. But that’s a really bad example, and doing that would be a bit silly. Because you may as well just do “Is Registered is not true” and be done with it. Okay, that’s the limit of my creativity. I’m sure somebody else can give you a much better example. ---
**Author:** ![L.M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/l.m/32/46371_2.png) [@L.M](https://community.glideapps.com/u/L.M)\ **Post date:** [November 7, 2021, 11:01am UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/79 "2021-11-07T11:01:26Z")
Very kind of you 🌸 to try, Darren. OK, I’ve made a “sightseeing tour” of the Data Editor & Computed Columns / plugins and registered somewhere in my head at least 1 possible example, except this one. Some day, some one, maybe? I’m sure the story with the “lie detector” can serve this purpose: any Sherlockians, Team-Loki & Spooks / Special Agents here? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 7, 2021, 2:14pm UTC](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964/80 "2021-11-07T14:14:29Z")
I think Falsey and Truthy will compare to several different values. Falsey will return true if you feed it blank, false, no, 0, etc. Truthy is obviously the opposite and looks for positive values. If you look at the code, you can see the different values that it checks for. I think the point of these plugins are too check for a variety of different values that are true-like or false-like instead of checking only for true or not true. [Previous page](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964.md?page=3) [Next page](https://community.glideapps.com/t/all-new-data-editor-computed-columns/33964.md?page=5)