# March Challenge - Calculator **URL:** \ **Category:** Project Showcase\ **Created:** [March 11, 2021, 5:39am UTC](https://community.glideapps.com/t/march-challenge-calculator/24091 "2021-03-11T05:39:17Z")\ **Posts on this page:** 20\ **Page:** 3
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [March 15, 2021, 11:13pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/41 "2021-03-15T23:13:56Z")
Amazing! ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [March 24, 2021, 9:59pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/42 "2021-03-24T21:59:14Z")
@Jeff_Hager time to do a bit more on the calculator. Thought I would do a history thing as you showed. But it seems as I cannot copy user specific variables to user specific variables in a history table. I cannot see that I can use row owners as the person is not signed in. Maybe you can give a hint on to how-to do a history of entries 🙂 ---
**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:** [March 24, 2021, 11:41pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/43 "2021-03-24T23:41:56Z")
This is by far the most impressive glide app I’ve seen this year. 👏👏👏 ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [March 25, 2021, 8:30pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/44 "2021-03-25T20:30:06Z")
@Jeff_Hager Cool idea to colorize the buttons that you cannot use in red - the user then understands which buttons not to push. I did get the history to works - thanks for letting me think 🙂 ---
**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:** [March 25, 2021, 8:54pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/45 "2021-03-25T20:54:27Z")
Sorry, I was intending to get back to you, but I’ve been busy with other things lately. Yeah, the red buttons started out as a way for me to visually debug which buttons were clickable and which were not. I kind of like how it works, so I kept them. I’ve been picking away at those conditions for a few weeks to disable buttons and prevent user’s from trying to enter something they shouldn’t. It’s been an absolute nightmare. I either find a new scenario, or I break something while fixing something else. I think I’m really close to having it all locked down, but I still have ideas for more to things to add. These are my conditions just to determine if any of the buttons can be clicked (and turn red if not). It’s gross. In a perfect world, it would only be 2 IF columns with a mix of AND/OR conditions. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/d/fd05e4a8b0f83a3126525bf19407c0981ff730f3.png) ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [March 25, 2021, 9:02pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/46 "2021-03-25T21:02:03Z")
@Jeff_Hager wow. That’s a lot of ifs. The way I implemented history records doesn’t suit me that well. It seems as you _cannot_ add a value to a user specific variable when using Add row action (in compound action). This means that if all users has a history of 10 then 50 users will create 500 rows which everybody needs to download. If the variable was user specific then the individual user would just have 10 rows. ---
**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:** [March 25, 2021, 9:11pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/47 "2021-03-25T21:11:35Z")
So, I kind of hinted at it in my other bug post, but what I did is create 20 rows in a history sheet. There is a static row number column for each row, some user specific columns to hold unique values for each user, and then some logic column to determine which row is the next one to be updated. If all rows are empty, then it will say NEXT for all rows, but a single relation to that history sheet will only find the first row that says NEXT, so that is the one that’s updated. Once all 20 rows are filled, then it determines the row with the oldest date/time and only that one is set with the NEXT key value, so from that point on, it’s always the oldest row that get’s replaced. I don’t use an Add Row action at all. All of the rows in all of the tables are static. Right now I have 48 rows total for the app, and that number will never grow…unless I add more features. 😉 It’s been working great, but I noticed today that I have a couple of weird issues with the Set Columns action that I’ll need to submit to support. This is my history sheet. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/883e105d53241c05193ed77c6cc330ec48a1f978.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d62f022f7a6257c225693a13d81c27a89348036a.png) ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [March 26, 2021, 12:36am UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/48 "2021-03-26T00:36:06Z")
This is unreal. ---
**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:** [March 26, 2021, 3:11am UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/49 "2021-03-26T03:11:33Z")
I feel kinda bad that I haven’t contributed to this challenge. Early in the month I had the idea of building a calculator that worked with Roman Numerals, and I made a very early start on it. But I very quickly realised that I wouldn’t be able to justify allocating the time it would take to figure it out and get it working - or if it would even be possible. So I abandoned the idea 😢 Oh well… maybe that can be the April (or May) challenge 😆 ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [March 26, 2021, 7:00am UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/50 "2021-03-26T07:00:37Z")
@Darren_Murphy well that challenges has taken a lot of hours from me this month. And Jeff keeps raising the bar😜 ---
**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:** [March 26, 2021, 12:45pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/51 "2021-03-26T12:45:38Z")
Hehe, sorry about that. It’s taken a lot of my time too. It was supposed to be a simple “can I do it” challenge. Then I saw all those unused trigonometry functions, and figured I had to put them in too. That’s when it went off the rails. Then I got really picky and went through all the work to attempt to make it dummy proof by dynamically locking down buttons. I still have other plans, but I really hope I have a stable version next week when I allow it to be copied. ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [March 28, 2021, 2:03pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/52 "2021-03-28T14:03:43Z")
@Jeff_Hager I am not happy with this state of affairs at all. When are you making the copy available? I cant wait to clone it and present it as my own work of art 🤣 🤣 🤣 ---
**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:** [March 28, 2021, 3:40pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/53 "2021-03-28T15:40:05Z")
4 days Wiz, 4 days. I’m hoping to have a few final bugs worked out by then. 😉 ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [March 28, 2021, 3:42pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/54 "2021-03-28T15:42:57Z")
Okay i’ll bear the pain…after 4 days no more excuses, I want it on my desk 🤣 🤣 🤣! Great piece of work @Jeff_Hager ! 👍 👍 👍 👍 👍 👍 ---
**Author:** ![MonsterGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/monstergo/32/18780_2.png) [@MonsterGo](https://community.glideapps.com/u/MonsterGo)\ **Post date:** [March 28, 2021, 3:56pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/55 "2021-03-28T15:56:31Z")
Excited! 🤩 ---
**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:** [March 28, 2021, 4:07pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/56 "2021-03-28T16:07:39Z")
> [@Jeff\_Hager](#): > > 4 days Wiz, 4 days. I’m hoping to have a few final bugs worked out by then. 😉 @david better crank up the bandwidth to prepare for the DDoS that’s coming on April 1 when everyone grabs their copy 🤣🤣🤣 ---
**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:** [March 29, 2021, 3:01pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/57 "2021-03-29T15:01:15Z")
I just noticed this… 🤣 🤣 ![Screen Shot 2021-03-29 at 10.55.49 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/aeba9a06e0a129fbcff60dea80e605840dd9437c.png) @Jeff_Hager any theories as to why the number 5 is by far the most popular key? I guess my theory would be because it just happens to be the one in the middle… PS. You need to implement scientific notation 😛 🤣 ![Screen Shot 2021-03-29 at 11.05.26 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/7/07b173eec2408ca38870abe45a69897c5debc22c.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:** [March 29, 2021, 3:35pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/58 "2021-03-29T15:35:27Z")
Hehe, kind of a fun addition to see if people are using it and see a live count. It’s a little aggressive though, since it records every button press, so I plan to disable the global count and switch it to a user specific count, which should be stored locally, unless a user signs into the app. That way it’s hopefully not pinging Glide’s servers so much. The ‘5’ button is probably the one I press most often when testing. I tend to run the same calculations through over and over until I work out a bug. I’m sure it’s mostly because of me…and because it’s in the middle. 😉 No! I don’t want to add scientific notation. Use smaller numbers! 😉 I consider it a feature that Glide can handle larger numbers. 😇 Although I wish I had more flexibility for number formatting. I’m just happy that I figured a way to get it to calculate past glide’s maximum of 4 decimals, but what bugs me is a lose the ability to have a group separator, since it’s ultimately converted to a text value. ---
**Author:** ![MonsterGo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/monstergo/32/18780_2.png) [@MonsterGo](https://community.glideapps.com/u/MonsterGo)\ **Post date:** [March 30, 2021, 4:29pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/59 "2021-03-30T16:29:54Z")
Hi Jeff, May i know what is the CSS for the pressing button effect ? ---
**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:** [March 30, 2021, 4:34pm UTC](https://community.glideapps.com/t/march-challenge-calculator/24091/60 "2021-03-30T16:34:35Z")
Here you go. > [@Indicate button/tile pressed](https://community.glideapps.com/t/indicate-button-tile-pressed/24781): > > How do you make a button/tile show like it is being pressed like shown in the video From the app shown in this post: [Previous page](https://community.glideapps.com/t/march-challenge-calculator/24091.md?page=2) [Next page](https://community.glideapps.com/t/march-challenge-calculator/24091.md?page=4)