This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hallo, it's my first appSheet experience, I need to track operator
activity, the idea was to use google form + google sheet + google app
script, but appSheet seem to be more friendly for user .The goal is to
let the user to track the activity time an...
Hallo,I'm new to AppSheet, i need to have a form to let users fill a
spreadsheet, the users should not view the data from the spreadsheet.
just like a google form, but using an app.After looking around i
could'nt find a way, is it possible?
Found solution for question number one,The PIVOT table manually filled
to test the graph now is filled by query and filter
formula!=QUERY(TESTDATA!A:H,"select G,F, SUM(H) WHERE G<>'' group by
G,F")This query sum hours grouping by user and activity ty...
I found solution for the question number 2, a simple edit to the
computed column formula done the job!Still working to find a solution to
have group totals as in this exampleOf course the various activity type
(tipo lavoro) may be mixex.
Hallo I'm MarcoIn what part of the world do you reside?I live in
ItalyWhat do you work on?I'm a develeper and analist in an italian
municipalityWhat expertise do you have to share or what are you
learning?almost 40 years in IT, developed in many lang...
I don't want the user can see this system generated detail view. They
have to put data, and i will create a syntetic view to let any user
check his own data and the supervisor have a full view. The initial idea
was using google form + google spreadsh...