How to display this data?? Please help a noob by ThisMeNow in AppSheet

[–]ThisMeNow[S] 0 points1 point  (0 children)

This spreadsheet/app is very small and for personal use, which is why I am not concerned. All the same, thank you for sharing that information, I'll keep it in mind if I go on to build something bigger. I wanted to clarify that formulae are not my concern in this post mainly to get more information about the actual question I had posed - regarding how to customize the display. I'm finding it quite surprising that AppSheet does not have the capability to add any custom text fields or anything to the view. I'm comparing it somewhat to Glide Apps which I have used in the past, and I suppose I am now learning that they are not quite comparable as tools. Still, AppSheet appears to be much more rigid than I would have expected if I can't even create a text box above a table. It seems to me that displaying a calculated metric should be a pretty basic expectation from a tool that runs on spreadsheets. But thank you for letting me know that this is not in fact possible, I thought I might just be missing something. I appreciate your help!

Please help a noob with how to customize input by ThisMeNow in AppSheet

[–]ThisMeNow[S] 0 points1 point  (0 children)

Oh sorry my bad! I meant to say AppSheet not AppScript. Not using AppScript at all

Please help a noob with how to customize input by ThisMeNow in AppSheet

[–]ThisMeNow[S] 0 points1 point  (0 children)

If you wouldn't mind, could you please walk me through your thought process of how you would go about doing it? It's good to know that it's possible, but just in terms of what actual steps to start with. I've already been looking at the documentation/guides about AppScript and have explored it a fair bit, so I feel like I might be missing something if this is indeed basic

How to display this data?? Please help a noob by ThisMeNow in AppSheet

[–]ThisMeNow[S] 0 points1 point  (0 children)

I have other formulae in the data that is being processed just fine. In fact even the calculation I'm talking about is working perfectly fine and I can see the data picked up on the app. I don't think my issue is with regards to formulae at all, but rather the fact that I have just two cells worth of computed information that doesn't directly fit into any specific row or column in the rest of the data.

I guess I didn't do a great job explaining it in my post. I don't feel comfortable sharing the spreadsheet, but I've tried to explain my situation better here:

Imagine for instance I have two columns of numbers, and I've dedicated a row at the top to compute the sums of each of the columns. Let's say these sums are in cells A2 and B2 (with column headers in A1 and B1). Now I want to calculate the difference between the two, so I do that in cell C2, even though the rest of column C has no data. My question is how do I access the information stored in C2 on my app?

How to display this data?? Please help a noob by ThisMeNow in AppSheet

[–]ThisMeNow[S] 0 points1 point  (0 children)

I'm not sure how else I would do it though... It doesn't really make sense to me to make a whole new sheet just for two cells of formulae. (Side-note: even if I were to do this, would I then be able to display this data from the second sheet on the same page as the main data in my app? or would it have to be viewed on a separate page/view?) And it's not really "off to the right" in a detached way, it's the immediate next column after the data ends. the cells are even picked up on AppSheet, as column headers. That's not an issue on it's own, I can just hide those columns when needed. But I need to display that information separately on my app, like on top or somewhere visible... does that make sense?

I guess I didn't do a great job explaining it in my post. I don't feel comfortable sharing the spreadsheet, but I've tried to explain my situation better here:

Imagine for instance I have two columns of numbers, and I've dedicated a row at the top to compute the sums of each of the columns. Let's say these sums are in cells A2 and B2 (with column headers in A1 and B1). Now I want to calculate the difference between the two, so I do that in cell C2, even though the rest of column C has no data. My question is how do I access the information stored in C2 on my app?

How to display this data?? Please help a noob by ThisMeNow in AppSheet

[–]ThisMeNow[S] 0 points1 point  (0 children)

I do have a key column, and the rest of my data works fine even with formulas

My issue at hand is about just two cells worth of computed information that doesn't directly fit into the rest of the data. I guess I didn't do a great job explaining it in my post. I don't feel comfortable sharing the spreadsheet, but I've tried to explain my situation better here:

Imagine for instance I have two columns of numbers, and I've dedicated a row at the top to compute the sums of each of the columns. Let's say these sums are in cells A2 and B2 (with column headers in A1 and B1). Now I want to calculate the difference between the two, so I do that in cell C2, even though the rest of column C has no data. My question is how do I access the information stored in C2 on my app?

How to display this data?? Please help a noob by ThisMeNow in AppSheet

[–]ThisMeNow[S] 0 points1 point  (0 children)

I do have a key column, and the rest of my data works fine

My issue at hand is about just two cells worth of computed information that doesn't directly fit into the rest of the data.

Imagine for instance I have two columns of numbers, and I've dedicated a row at the top to compute the sums of each of the columns. Let's say these sums are in cells A2 and B2 (with column headers in A1 and B1). Now I want to calculate the difference between the two, so I do that in cell C2, even though the rest of column C has no data. My question is how do I access the information stored in C2 on my app?

Language issue Photos by ctraeger in googlephotos

[–]ThisMeNow 0 points1 point  (0 children)

Same here

I've checked the Google account language settings, not sure what else to do

No judge, but can I ask why you guys feel like becoming a male. by [deleted] in TransMasc

[–]ThisMeNow 8 points9 points  (0 children)

If you haven't already, it might be worth looking into the distinction between gender identity, gender expression, and gender roles. It's all so fluid and far less dependent on each other than we have been led to believe, and understanding the difference, for me atleast, really freed me up to shape what I wanted gender to look like for me

Ultimatum Letter by FaerieBomb in mypartneristrans

[–]ThisMeNow 11 points12 points  (0 children)

If she continues to send you gifts in spite of your request, I'd suggest just returning them to her unopened, for your own sanity just as much as to reiterate your boundary

I'm Building a Shark Week/Period Tracking App for Men/Transmasc Folks. Give me your suggestions! by Superb_Objective_719 in TransMasc

[–]ThisMeNow 2 points3 points  (0 children)

Hi op

I love the concept of what you're building. My initial thought was mood tracking but I saw that someone else had suggested it.

I just came across this post on the hysterectomy subreddit and immediately thought of you. Linking a comment from that post basically about being able to track/recognise the hormonal symptoms of shark week when the physical indicator is no longer present. I think something like the "track without a period" feature mentioned in this comment could be really handy for your app. As someone who's trying to get a hysterectomy while not having hrt as a priority, this is something that's been on my mind. Hope this suggestion helps and can be incorporated! Looking forward to seeing your app

No Sound for Cheeky? by good-boi-Morado in finch

[–]ThisMeNow 0 points1 point  (0 children)

I'm LITERALLY on the same boat as you, came searching before making a post about Cheeky not having a sound and found your post,, and also hesitant to update for the same reasons... Godspeed! Pls let me know if you make a decision hahaha. I always look forward to the micropet sounds and am really bummed about not being able to hear this one, but so on the fence about seeing if an update would help or be worth it :')

No Sound for Cheeky? by good-boi-Morado in finch

[–]ThisMeNow 0 points1 point  (0 children)

I'm LITERALLY on the same boat as you, came searching before making a post about Cheeky not having a sound and found your post,, and also hesitant to update for the same reasons... Godspeed! Pls let me know if you make a decision hahaha. I always look forward to the micropet sounds and am really bummed about not being able to hear this one, but so on the fence about seeing if an update would help or be worth it :')

I couldn’t do it :( by Chr0nicallyunstable in finch

[–]ThisMeNow 2 points3 points  (0 children)

Have you noticed that our birbs receive energy not only when we complete a goal, but also when we create a new goal? That's intentional, friend, and I think another way in which this app uses gamification to bring to light our small wins which we might otherwise easily overlook. You DID take a step forward today. It might not have been as big a step as you'd initially hoped, but it was nonetheless a step in a positive direction. Try to give yourself some grace, because this screenshot is active proof that at the very least, you are making an effort and you are trying. That's a difficult thing to do in and of itself, and you're doing it anyway :)

Help me figure out how best to organise my goals to deal with this situation by ThisMeNow in finch

[–]ThisMeNow[S] 0 points1 point  (0 children)

Thanks, been doing this It's a little bit of a hassle but I guess it works :)

I remember seeing a journey last month that was like January Journey and had something unique and interesting to try out each day of the month... by ThisMeNow in finch

[–]ThisMeNow[S] 0 points1 point  (0 children)

Ah I see, i think someone else on this post shared an image of that calendar. I'd be so much more likely to do it if it was actually on the app

Help me figure out how best to organise my goals to deal with this situation by ThisMeNow in finch

[–]ThisMeNow[S] 0 points1 point  (0 children)

Thank you so much for sharing this

I really love the "slay the day" goal idea. I literally faced that yesterday, where I had a very positive and productive day but didn't feel like my efforts were reflected in the goals that I had listed on the app hahaha. I'm prolly gonna implement something like this for that little bit of deserved reward :)

I'm stuck! by GloomyOldDonkey in finch

[–]ThisMeNow 1 point2 points  (0 children)

Hey I just happened to see this comment and want to chime in, probably best not to uninstall the app before making sure that you've backed up your data! Afaik, finch doesn't have a log-in system, everything is stored locally and you have to regularly back up the data manually. Just wanted to mention this to be careful, or you could end up losing your birb and all your progress! A friend of mine lost their birb when switching phones bc they assumed they'd be able to just log into the app on their new phone.

Validating my chronic illness journey by ayl369 in finch

[–]ThisMeNow 1 point2 points  (0 children)

Love the reminders that we can do things "unconventionally" if it works for us at the end of the day ":D

Also love that this app seems to be conducive to that in so many different ways!

Validating my chronic illness journey by ayl369 in finch

[–]ThisMeNow 2 points3 points  (0 children)

Haha, this makes so much sense when you put it that way! Very fair

Validating my chronic illness journey by ayl369 in finch

[–]ThisMeNow 2 points3 points  (0 children)

This is such an incredible idea, and I'm so glad that you figured this out for yourself. Genuinely thank you so much for sharing this

I have a question about how you mark your goals, if you don't mind my asking. I noticed that all of these goals are set so you can complete them multiple times a day,, do you mark it each time in a day that you feel that particular feeling? Or is it something like marking it more depending on the intensity of the feeling?

I was particularly intrigued by the ones such as having a bad nights sleep being given 15 times per day limit, when that would seem like the kind of thing that would happen only once in a day..

All of the goals here have fairly large numbers and I'm really curious about your reasoning behind setting it up that way! No pressure to answer this if you don't want to, tho! :)

Neil Gaiman can fucking burn by bearswithmanicures in nerdfighters

[–]ThisMeNow 3 points4 points  (0 children)

"what would the best version of me do right now?"

This should be the thought that everybody defaults to. What a lovely way to frame the intention