Newbie looking for help converting Sheet into app

Ok. Sorry, but this forum limited me to how many responses I could make. I saw the virtual app and I responded on that with a message and was wondering if you got the message. I will check it out again. I had about 4 or 5 bullet points in that message. Thank you so much for helping me with this. It’s so close to what I wanted. Let me see if I can remember the bullet points that I had. .
I like this app, but there are some limitations that I would like to overcome.

  1. In Sheets, if I set the interval incorrectly by accident and notice a few days later and set it properly, all of the times in the history will update. Here, it does not update.

  2. Sometimes I do slip up and take the medication and forget to enter it, for whatever reason. In Sheets, I can tap on the row and choose insert line above and I usually can recall the time, but sometimes, i can’t so I just make a guess. Usually I have something that will help me remember the time like like I ate at 12:30 and took it right after around 12:45 and I am able to insert that so that my history shows this. With the pain medicine that I take, this history part is very useful. I need to be able to insert it somehow.

2a. Lets say that I took the med 30 minutes ago but I just remembered to add it. Is there a way that this can be made to be able to edit the time so if I put it in now, I can change the time back to 30 minutes ago?

  1. The next dosage time is showing up as January 1, 1970 when I put it in.

  2. Are you able to make it where I see the next dose time right under the time it was taken in the first screen right under the pill name?

  3. Not often, but sometimes I am about to take a pill, I put it in my phone and get interrupted right at that moment and forget to put the pill down the hatchet. I may not notice until I’ve taken a couple of other meds so I need to actually delete the entry and take the pill as soon as I can. In Sheets, I just delete the row.

Im sorry that my explanations are not well constructed. I will make another video on my iPhone showing what I’m talking about and will share it again.

Thank you. This is looking really great and I like the look of it. I am curious (being that I’m always asking for choices) is thre a way to make a setting button so that I can choose the color of the screen? I like the black myself but my wife likes white. New York clothes are black, my car is black… I just like the darker colors. My wife is opposite. For all those items, my wife likes white. So, I was just curious if that could be made an option. Black background, white text, white background black text. I guess we would need to be able to choose the background color and the text color. If that’s going overboard then the color it is now is great. Thank you so much!

1 Like

Here is a link to the new video that I made. I hope by seeing this it helps to understand the editing features that I need and the reasoning. Also, Can we name this Personal Dosage Tracker? Here is the link to the video. I have it set for whoever has the link should be able to see it. Again, I can’t thank you enough.

That’s weird. It let me share my video yesterday. Now it is saying that I can’t post a link to that host.
Lets see what I can do with the loom.

https://drive.google.com/file/d/1BRqHnWU6F3VDSgHh-EnD-todHf1Mf-BJ/view?usp=sharing?

1 Like

Hi. I was wondering if you saw my new messages?

1 Like

Hi @Somps sorry, I just noticed everything.

  1. It will change in this case as well, I have used the same formula
  2. I will add an option to create a past entry.
    2a) Will add an option to edit past entries.
  3. Fixed it. Needed to change formatting on the google sheet.
  4. The format can be changed to the way you want. I will share the app and you can make a copy of it and make those adjustments.
  5. There can be an option to delete the entry.

For formatting, you could copy the app and try out the colours you like. There’s an option to match the device theme so it will adjust to light mode or dark mode according to the device. Will make the changes soon and share. You can then make a copy of the app and use it.

3 Likes

Thank you.

1 Like

Manan_Mehta really I don’t know how to thank you, but your coffee is on me! Great Man! :slightly_smiling_face: :slightly_smiling_face: :slightly_smiling_face: :slightly_smiling_face:

Somps, hope you get better soon! keep in touch with us!

2 Likes

Well, I am on permanent disability and I have wanted to learn something like this for a while. I’ve gone through some training courses on programming. I guess, for me, it’s deciding to learn the new vocabulary as programming is just another language. I understand all of the principles well enough. I’m just waiting to find an area to dive into. Of course, for me, money is the biggest problem so I have to find ways to learn for free. Paying somebody to teach me would be faster, but I can’t afford that so I just have to find my way. I came across Glide several months ago and was wondering what it really takes. Do I need to know a programming language already? I saw that I should be able to convert a Google Sheet into an app and so I tried it and it didn’t work out for me so, at that time, I didn’t pursue Glide. I had signed up and was getting email on a regular basis, so a few days ago, I decided to reach out and ask if someone knew why my Sheet didn’t convert into an app. The person who responded suggested that I post in this forum, so I did and I was extremely surprised to get so many responses right away. You guys are really great. Now, my question is, is this something that I could learn to do? Would there be anyone willing to mentor me? I was one of those that didn’t need to study or work hard at learning a new field as long as I had somebody to watch and/or listen too. I have this ability to soak up information when it’s in a way that is comfortable, meaning that I am able to follow somebody. With that information. do you think that there would be anyone willing to help me to learn how to do what you guys do and do I need to learn a programming language? I had started with Swift but put it of for a little bit. Just wondering. I have ideas for apps and it would be great to be able to make some more like this if I could learn. So, what do you guys think? Do you think this is something someone in this community would be willing to help me out with? If anybody comes across this and is willing to help an old goat learn something new, I would really love to. Just let me know what is the best way for me to start and what I need to do and if there is a way for me to watch how you do it. Thank you all for your quick responses and for helping me!

1 Like

Thank you so much Wiz.

1 Like

Someday after this pandemic, let’s have coffee together instead :relieved:
Made the changes you wanted @Somps
Check the app now, also the app is copyable so you can copy it and make the necessary adjustments if you need! Let me know if it’s how you wanted

To edit/delete any entry, press any entry and click the edit button on the top right.
Incase you want to do any past entries, make a new entry and edit it.

1 Like

Thank you!

Thank you so much!!! I will play with it a bit to make sure everything is like I want it. Am I able to change the app name to Medication Dosage Tracker? I love you guys! In a totally platonic way, of course.

3 Likes

Yes once you make a copy, you can make adjustments. Also take care of yourself! I am glad that this will be helpful for you.

3 Likes

I myself need a mentor :slightly_smiling_face:But a good place to start is https://www.glideapps.com/learn-to-glide

1 Like

Well, I appreciate the help.

2 Likes

Thank you buddy. Hey, I do a little graphic design if you are ever in need of something. If its something I can do, I don’t mind helping.

2 Likes

By the way, one thing I completely forgot. I think I might have very briefly mentioned it but I didn’t elaborate. Google Sheets auto saves all my data in my account so I can easily export it for doctors. The history here, am I able to export it and another similar question is: is my data accessible to other People? Is this just creating a copy on my phone or is it running on a server of some kind in the cloud? Am I able to give the info to someone of my choosing (exported data)?

1 Like

All your data is stored in the Google Sheet owned by you. You can use it exactly the same way you used it before.

2 Likes

Hi @Somps

Check this one as well.
https://likeable-angle-1358.glideapp.io/

Note: Not fully accurate right now still work in progress.

2 Likes

I just saw it. Thank you! I think that I’m liking this very very much! So, if I give this app to one of my friends at my infusion center, if they login with a Google account, will it make this theirs or will it still be linked to my account?

1 Like

You can let them copy it to edit their own data in.

2 Likes