Best Of
User Interface
Has anyone found a good user interface that can be a better front end? I have a need to create something where a user can select one row from the interface and see the data presented on one screen and be able to make edits.
I would appreciate any direction on this.
Thanks!
Re: Searching for specific automations
Yes, I have been needing this for a while now. One of my sheets has over (30) automations and it's always a chore to find the one I want to edit or view. I can always remember a word or two so having a search bar to type keywords into on the workflow page would be very valuable and save a lot of time!
Notifications include Cell History
Please consider adding an option or field name (e.g. {{history-start date}}) within notifications to share what the cell contents were BEFORE a change occurred.
I have a notification that goes out to users when something like a start date changes in a Sheet. While I can send the new cell value in the notification, it would be nice to be able to include what the cell value was prior to the change. This information is already tracked within cell history, but would be helpful to include it in notification E-mails rather than the user having to go into the sheet and review cell history.
A sample notification E-mail might be:
The Start Date {{history-Start Date}} has been changed to {{Start Date}}
The Start Date 11/22/23 has been changed to 12/10/23.
Thanks!
Ken
Re: Rearrange Sheet Summary Fields - click and drag
Organize Summary Fields - Add Drag and Drop to Organize Several Fields
Scenario: Sheet has multiple summary fields and they have been created without giving thought to the order of each independent field.
Add ability to click on a field to drag and drop up/down in the list of summary fields to organize the order they are shown.
currently can only move up and down one spot at a time
Re: Rearrange Sheet Summary Fields - click and drag
I'd like to add having an option to pop out the Sheet summary screen to a different display, something bigger that's easier to see and work with and make edits.
Re: Rearrange Sheet Summary Fields - click and drag
Echoing Pauls' post - and the comments - please add this/some functionality
--
Currently to rearrange the fields in the sheet summary you have to open the field properties and then move it up or down one at a time.
If you have a good handful of fields and then realize that the three or four at the bottom should actually be at the top... That gets to be rather tedious.
Would would be great is if we could click and drag the fields to rearrange them similar to rearranging the fields when creating a form.
Grabbing multiple fields and moving them using the click/drag method would be even better! (same goes for on forms).
I have already submitted a Product Enhancement Request for being able to click/drag a single field, but I think I may also Submit a Product Enhancement Request or two for being able to click drag multiple fields instead of my original click/drag a single field, and for doing the same (multiple fields at the same time) when building a form.
Just figured I would put it out there to see what other people think about it (link provided if anyone else wants to submit and enhancement request).
Re: Lock single cell
I agree, this would be a useful feature which would allow me to error-proof a process. Currently I have a published sheet in which many of the rows and columns are locked, but a few need to remain unlocked as it requires the user to manually input data into cells within them. However, there are other cells within that same row/column that they should not be editing/deleting formulas from, but are currently able to and often do in error. If I were able to lock those single cells within the sheet, this would prevent them from deleting the formulas.
Re: Dashboard - Page Break Line/Preview in Edit Mode
We are saving as PDF every week so we can compare progress to the previous week's dashboard, since the online version updates every time you open it. I have an extra blank PDF page at the bottom of every PDF since you can't adjust the dashboard page size. These PDFs may also go to Sr Mgmt. It looks sloppy. I agree it would also be great to be able to adjust the PDF version to show all lines of a report rather than just the visible part that shows on the interactive online version with scroll bars. I do not want to expand out every report since that would make it difficult to navigate while showing in a meeting or for users to see what's going on by using the most current online version. It would be nice if there was a way to show snapshots of the dashboard or reports as of a certain date as well as the most current version, so you can see how things are changing more easily than having to print to pdf.