You can just share your spreadsheet and let people edit it directly. Or you can create a google form and send that out. Both accomplish the same goal without an app you need to load and keep updating on your phone.
Hi Charlene - we're so happy to hear you liked our tool! Join our Google+ Community to learn how others are using the tool and get tips and updates: community.appsheet.com
wow. this looks exactly like what I need. Google Forms just don't have enough options for my current needs and drive spreadsheets can be dfficult to manage on a phone. Thank you!!
Import Google Sheet into MySQL db-"google sheet es mysql converter "-copy/paste in Google search. ONLINE converter-option "Google Sheet to SQL".Generates SQL insert script from Google,Access or Excel table ,you can import in SQL databases by manager program.
Thanks for this - it's a **HUGE** help. I've already turned my spreadsheet of several thousand pieces of equipment for our radio network into a shareable app. WOW! Again, thanks!
Went through this then found to require login for app, one needs premium (paid) appsheet account. Unlikely that someone would hack the demo church attendance database but...
Slingshot is MUCH better and the payout is more. I joined at $50 and three weeks later already been paid $4,700 in cash plus they give you a full refund if you can’t find your 2nd person. Best thing that ever happened to me.
hello everyone, I have a problem with app sheet. when i click on "make new app" it says that the page could not be found. What is the problem with it? please help me out
Charlene, thank you sooooo much you are a life saver! I have one question however. If I Create a customer database, will I be able to enter Images to each person along with editing their information?
Mam I have a doubt on chaining the html pages. Is it possible to switch to a new html Page when a button is clicked? Please do clarify the doubt. It will be really useful for my project.
This almost matches with what I am planning Can we add print button and wireless printer interface ? Also data needs to be presented in RECEIPT format before printing. Anyone tried this?
There is multiple ways you could do that. I'd suggest exporting a CSV and Importing it into google sheets to print. Or you could Create a Google Doc Template and allow it to auto fill neatly!
Este sistema,... es solo para uso en mi teléfono, o se lo puede compartir para que otros teléfonos de mis compañeros también ayuden a ingresar datos? gracias por tu respuesta
can i set here to other person email id also. after putting all details in app that data excel sheet should go to other person email id also.is it possible?
Hi Charlene loved your video. In your opinion do you think this site/app is safe. I would like to use it at work form employee data like soc sec num, dob, etc... Thanks
hello, there is change in site setting data tab is not having user settings as shown in video , now different settings i am not able to do as per tutorial.kindly guide me
My channel has lots of AppSheet tutorials that is on their new UI. Also tons of other resources released by the AppSheet Team. AppSheet has became so much more powerful and easy to use over the pass few years!
were you able to create a mailing list database? I'm trying to learn to build phone number list to cold call without having to outsource this step and pay
My channel has lots of AppSheet tutorials that is on their new UI. Also tons of other resources released by the AppSheet Team. AppSheet has became so much more powerful and easy to use over the pass few years!
Yes. You can change data from your sheets or forms, or from the app. We don't have a checkbook app for now. But there are a lot of interesting sample apps that you can copy and customize. www.appsheet.com/SampleApps?q=&hPP=100&idx=help&p=0&is_v=1
can you help me, i need to scan barcode to two documents at the same time i created 2 Excel workbooks the first one is : Daily Record and the second is : Invoice Record what i want to do is : when i scan a barcode to a specific column in the first workbook , the barcode No. will also goes/auto copy to specific column in the second workbook. Please Help i need an idea on how to do this
Im not sure, and don't currently have the time to investigate. Maybe check out APPSheet's google community for help? plus.google.com/communities/117336961081239352051
I mean, information that you input in the app uploads and saves on your google spreadsheet. For instance, I have the app on my phone. At church, I input the number in the congregation. Refresh. I can then go to the spreadsheet in our google account and the updated numbers are there.
Video wasn't very helpful. Tried to follow step by step but what is showing on video doesn't match actual appsheet display. No explanation about what/how to enter information into google sheet. At about 5:30 she talks about not wanting sample data .. as I did mine, there was no question about sample vs using own data. When click on 'Data' in left nav, what I see doesn't look like what is in video .. continues like that for rest of video. So, in the end, this was not helpful for me.
ONE of the the greatest tutorial on youtube featuring the power of GOOGLE and APPSHEET. Thanks Charlene.
india oldies
Great! You can use Sheetsu.com for faster Google Spreadsheet integration.
looks promising,but the headers/titles are not showing> can you make them to show or display
Christian Peregrino
Maria Lupe Sante
llan
One of the BEST tutorials I've ever seen. Focused on exactly what I needed. No meaningless technical crap that a beginner doesn't need right away.
Incredible discovery and great tutorial..... Thanks for sharing.
Thanks for sharing your knowledge step by step in a way to make us understand
your voice is so relaxing, too!
Thank you for saving me the time in figuring this out! Very easy to follow.
You can just share your spreadsheet and let people edit it directly. Or you can create a google form and send that out. Both accomplish the same goal without an app you need to load and keep updating on your phone.
plus.google.com/108969404877693764299/posts/Km3RMuUkxXC
martin Lee
Cameron Crest bmodi
rt
Isn't it much easier and smarter?
Thanks, will try this after the holidays!
OH! I loved this video! So excited to try it out!!! Thanks for showing us the process!
Ms. Sphon you explain very well! A born teacher! Thanks. I will try it out.
Excellent my dear, that´s great. Are lovely your tips are usefull in my job as professional of area adminitration of dates
ONE of the the greatest tutorial on youtube featuring the power of GOOGLE
Thank you so much..... Most useful tutorial and easy to understand...
You are welcome!
I appreciate that ya'll are still commenting on this tutorial, that I created 5 years ago... some things may have changed?! Lots change in 5 yrs. lol
Updated Tutorial?
THE most BEAUTIFUL and CLEAR Tutorial.
Thanks for taking the time to create a video. Happy to have an option in addition to AI2.
very good demonstration
Hi Charlene - we're so happy to hear you liked our tool! Join our Google+ Community to learn how others are using the tool and get tips and updates: community.appsheet.com
AppShee
wow. this looks exactly like what I need. Google Forms just don't have enough options for my current needs and drive spreadsheets can be dfficult to manage on a phone.
Thank you!!
Thank you Charlene Sphon, very simple way to work with google sheet and Appsheet. Keep Posting ... Good Luck.
Thank you so much!! You have no idea how long I've wanted to do exactly this
oh yea man, I don't know how happy i was when i found this
Fantasize video. I was wondering why the column headings did not come over. Thank you for sharing.
I love this! I've tried this to one of my task process and it evolves very well! Fantastic job on making this tutorial Charlene! :)
Glad it was helpful!
Import Google Sheet into MySQL db-"google sheet es mysql converter "-copy/paste in Google search.
ONLINE converter-option "Google Sheet to SQL".Generates SQL insert script from Google,Access or Excel table ,you can import in SQL databases by manager program.
Thanks for this - it's a **HUGE** help. I've already turned my spreadsheet of several thousand pieces of equipment for our radio network into a shareable app. WOW! Again, thanks!
Just what I was looking for! Thank You!!
so beautiful voice and info
Excellent work! Also you have a lovely voice! Have a nice day!!
Excellent and great effort
I really like your voice. You sound like an indecisive actress #in a good way. Thanks for the tutorial by the way. Stumbled upon it
Indecisive is very *clears throat* accurate. ;)
Holy sheet. This is amazing
Good tutorial. Thanks
Charlene, thanks for the video
Very useful ! Thanks for sharing !
Amazing! :) and wow too great for your first tutorial
Went through this then found to require login for app, one needs premium (paid) appsheet account. Unlikely that someone would hack the demo church attendance database but...
Slingshot is MUCH better and the payout is more. I joined at $50 and three weeks later already been paid $4,700 in cash plus they give you a full refund if you can’t find your 2nd person. Best thing that ever happened to me.
This is very helpful! Thank you
how set functionalities to search, filter, sort, paginate, etc. to the app from the datasheet?
Nice workout by AppSheet to integrate with Googlesheet. The AppSheet UI does not look quite impressive. I wonder if it is better customisable?
Thanks for sharing....will start using it
THANKS AND you have a lovely voice cool accent :)
Just what I was looking for. Thanks
super Video watched in TH-cam............. Great
Great help indeed. Thank you
does the app integrate MathJax to show marhematical formulas stored as LaTex in the spreadsheed?
You are Awesome!
I am facing a small problem. Even though there are 10 sheets in the Google spread sheet, in the App it shows only five. How can i view the rest?
hello everyone,
I have a problem with app sheet. when i click on "make new app" it says that the page could not be found. What is the problem with it?
please help me out
Awesome 👍👌
So use a fake google account but then add the app to your phone?
Great information.
Charlene, thank you sooooo much you are a life saver!
I have one question however.
If I Create a customer database, will I be able to enter Images to each person along with editing their information?
i want to know how to use spellnumber in google sheets?
Charlen, thanks in advance but i can see id =entry_?????? with view source of form page
I get that also, once in a while. It's not super great with formula's, it seems. Honestly I can get it to do what I want, so I havent tried to fix it.
Mam I have a doubt on chaining the html pages. Is it possible to switch to a new html Page when a button is clicked? Please do clarify the doubt. It will be really useful for my project.
Hello, " Google sheet to MySQL converter" - to find useful and accurate online converter . Hope it helps !
This almost matches with what I am planning
Can we add print button and wireless printer interface ?
Also data needs to be presented in RECEIPT format before printing.
Anyone tried this?
There is multiple ways you could do that. I'd suggest exporting a CSV and Importing it into google sheets to print. Or you could Create a Google Doc Template and allow it to auto fill neatly!
Beautiful.
Why not use Google forms? it helps in this regard.
can i know how to present the data report with chart?
Do you think that can we create a database consult interface?
Este sistema,... es solo para uso en mi teléfono, o se lo puede compartir para que otros teléfonos de mis compañeros también ayuden a ingresar datos? gracias por tu respuesta
Very cool!
can i set here to other person email id also. after putting all details in app that data excel sheet should go to other person email id also.is it possible?
Charlene, do you know how to use google forms in a mobile GIS app?
Loved it! Thanks
when you use some links in you tutorial please put the links in description
Why don't you just share the spreadsheet to users and install Google sheets app in mobile?
How to search record in google sheets data
Hi... a created app can be installed on a iphone? Or this works on android phones only? Thanks for your reply
How to create micro sheet in google spreadsheet
Thank you for sharing. Have you figured a way to include a formula to send you an email or text if one of your set conditions are reached?
I have not. I pretty much made the church catalog and my essential oil database and just continue to use them... ;)
Thanks for your response
Aurelio Dorris Bey not a formula. You can use some simple Google scripts to achieve that functionality.
Hi Charlene loved your video. In your opinion do you think this site/app is safe. I would like to use it at work form employee data like soc sec num, dob, etc...
Thanks
Appsheet is very expensive for small projects so why not use google forms with sheets to do all this instead. It's totally free.
Google Form will do it better.
Ok then show me how you delete something from a sheet with a google from...
@@FetzenRndy ok, who need to delete something from sheet except it owner?
HOW CAN I SEARCH A PARTICULAR RECORD IN GOOGLE SHEET? PLEASE HELP
help me to store the HTML form data to spreadsheet using java script
Can a user upload a document ?
nice video
Question.... can this app be shared with multiple people?
How to create a database to students mark sheet in app sheet please example the vedio
hello,
there is change in site setting data tab is not having user settings as shown in video , now different settings
i am not able to do as per tutorial.kindly guide me
My channel has lots of AppSheet tutorials that is on their new UI. Also tons of other resources released by the AppSheet Team. AppSheet has became so much more powerful and easy to use over the pass few years!
thanks, Im going to try to create a mailing list database.
were you able to create a mailing list database? I'm trying to learn to build phone number list to cold call without having to outsource this step and pay
Thank you for sharing.
I just tried it. The appsheet is not as according to the as shown in this video. Please Help
My channel has lots of AppSheet tutorials that is on their new UI. Also tons of other resources released by the AppSheet Team. AppSheet has became so much more powerful and easy to use over the pass few years!
thanks for the tutorial :)
Vikrant Singh q
So useful thanks
Can you update information that you've already put in from the phone app or app on the computer?
Yep. Just by logging in google drive and editing the spreadsheet.
Can you manipulate the data and display results (say like a checkbook app)
I really have no idea. Sorry. Appsheet has some videos of there own on here though!
Yes. You can change data from your sheets or forms, or from the app. We don't have a checkbook app for now. But there are a lot of interesting sample apps that you can copy and customize. www.appsheet.com/SampleApps?q=&hPP=100&idx=help&p=0&is_v=1
can you help me, i need to scan barcode to two documents at the same time
i created 2 Excel workbooks the first one is : Daily Record and the second is : Invoice Record
what i want to do is : when i scan a barcode to a specific column in the first workbook ,
the barcode No. will also goes/auto copy to specific column in the second workbook.
Please Help i need an idea on how to do this
Im not sure, and don't currently have the time to investigate. Maybe check out APPSheet's google community for help?
plus.google.com/communities/117336961081239352051
thanks for your help
thank you so much! it helps!
Charlene, thanks for the video. What software did you use for your screen share?
Thanks...gregg
+Gregg Ernst Sorry for the delay! I used screencast-o-matic.com/home (the free one).
Great information but Vedio is not clear.
What do you mean by "It backs up on your spreadsheet"?
I mean, information that you input in the app uploads and saves on your google spreadsheet. For instance, I have the app on my phone. At church, I input the number in the congregation. Refresh. I can then go to the spreadsheet in our google account and the updated numbers are there.
Charlene Sphon OK, then a more correct expression would be: "the data are saved in the spreadsheet file".
Don't look at my pictures or post
So, spreadsheets on church attendance and oil. I'm guessing.. Texas?
Charlene Sphon nice
Voice is sweet
Video wasn't very helpful. Tried to follow step by step but what is showing on video doesn't match actual appsheet display. No explanation about what/how to enter information into google sheet. At about 5:30 she talks about not wanting sample data .. as I did mine, there was no question about sample vs using own data. When click on 'Data' in left nav, what I see doesn't look like what is in video .. continues like that for rest of video. So, in the end, this was not helpful for me.