Widget/app that keeps track of google sheet

Toggle sidebar Toggle sidebar
J

Jonathanars

Prominent
Jul 11, 2017
3
0
510
Wondered if anyone knew anything about some app or widget that keeps track of # fields in google sheet with "X" and that "notifies" or shows the most recent change/new line in a google sheet.

I know that there's the google sheet app, but I'm more looking for something to put on a display and just leave it there all day.

This can be for either Android or windows.
 
Solution
Ralston18
Doubt that you will need another app or widget per se.

Likely to be a custom situation/requirement anyway....

Just create another spreadsheet linked to the original sheet. Use the second sheet to identify changes, sets the "X's, does any necessary tallies, etc.. Then just display the second sheet.

Or link/display the summary data via a database or into HTML for a fancier display if you wish.

Make the link "Read Only" so you can freely experiment.

Key is to identify some conditional that always identifies when a change has occurred. E.g., a timestamp of some sort. Or a comparison to a previously stored or captured copy of the data.

Start simple. Plan it out.

Work in steps. Pull the data over, identify the conditionals, turn...
Sort by date Sort by votes
Ralston18

Ralston18

Titan
Moderator
Oct 11, 2014
35,028
3,353
146,290
Doubt that you will need another app or widget per se.

Likely to be a custom situation/requirement anyway....

Just create another spreadsheet linked to the original sheet. Use the second sheet to identify changes, sets the "X's, does any necessary tallies, etc.. Then just display the second sheet.

Or link/display the summary data via a database or into HTML for a fancier display if you wish.

Make the link "Read Only" so you can freely experiment.

Key is to identify some conditional that always identifies when a change has occurred. E.g., a timestamp of some sort. Or a comparison to a previously stored or captured copy of the data.

Start simple. Plan it out.

Work in steps. Pull the data over, identify the conditionals, turn on the "X's" etc..

Once you are sure the content is accurate - then make the display pretty.

Seems like a fun sort of project....
 
Upvote 0 Downvote
Solution
You must log in or register to reply here.

TRENDING THREADS

Latest posts

Moderators online

Share this page

COMPANY
RESOURCES
FOLLOW
Top Bottom