Noob here. So feel free to explain it like I'm 5.
Will AppSheet allow for large volume cut/paste (see ex. below) from excel, text files, etc? I'm trying to create an app where a user can cut data from various programs or websites and paste it into AppSheet. From there the App will run a bunch of calcs, forecasts, etc. Ideally I'd like the user to be able to paste in ~100+ months of historic data, but at a minimum it needs to be 50 months in the format below. Even if the user has to paste in columns individually (like the "Data Source" allows) that would be ok.
Date | Widget |
10/1/2012 | 50 |
11/1/2012 | 48 |
12/1/2012 | 46 |
1/1/2013 | 21 |
2/1/2013 | 50 |
3/1/2013 | 52 |
4/1/2013 | 35 |
5/1/2013 | 45 |
6/1/2013 | 51 |
7/1/2013 | 50 |
8/1/2013 | 49 |
9/1/2013 | 43 |
10/1/2013 | 47 |
11/1/2013 | 38 |
12/1/2013 | 11 |
1/1/2014 | 55 |
2/1/2014 | 55 |
3/1/2014 | 52 |
4/1/2014 | 45 |
5/1/2014 | 43 |
Thank you for any help.
Solved! Go to Solution.
Unfortunately that is not possible directly through the app because the app works more on row basis. Have you thought to import the data with the CSV?
Unfortunately that is not possible directly through the app because the app works more on row basis. Have you thought to import the data with the CSV?
Thanks for the reply. I have thought about it, but users are going to have to convert data to a csv. I'm building this app to be more user friendly than a current excel model and this step moves in the opposite direction. The rest of the app would increase the UX, but I'm going to have to think id the tradeoffs are worth it.
What about if you paste the data into one long text column and then the app will generate those rows in the background?
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |