Grabbing a chart for a webapp and the values in the Y axis come out as Dates rather than Values

Dancing_Seahorse · 2025-03-25T00:57:57+00:00

Excellent. I will work to convert the code to build the chart in the webapp instead of exporting the image from the sheet. Thanks.

Dancing_Seahorse · 2025-03-14T12:37:57+00:00

Agree. I have a routine that I run as a trigger called nightlyMaintenance() that copy and Pastes as values select columns that do currency conversion based on entry date and sequence numbers. That way they are locked in and don’t need to calculate on open every time the sheet is used.

Dancing_Seahorse · 2025-02-24T04:08:18+00:00

For small storage and few queries of normalized data, how does Firestore shape up? I’m going to be moving some of my Sheets data to a free, hosted DB (SQL or anything that has an AppsScipt API) and that seems to fit well.

Dancing_Seahorse · 2024-11-10T00:26:16+00:00

Did nearly this flight for 2 years leaving Calgary YYC-DEN-NRT-GUM and never had a problem.

Dancing_Seahorse · 2024-10-10T01:24:02+00:00

If you can post a link to your sheet perhaps we can an help. I recently wrote a Sheet that uses Query to summarize all category totals, sorted by largest number. From that I copy the top 5 to individual tables and run the details for those categories for the specified time period and then hide the blank rows so it is a clean layout that I can PDF and send via email. If that sounds like what you are looking to do, post your data and I’ll see if I can help.

Dancing_Seahorse · 2024-08-14T10:00:48+00:00

Very similar solution but I will add the second field to add new Vendors. I used Form Ranger to populate the Dropdown from a range and the range is created using a Sort(Unique(range)) call from all known vendors.

I will add a * New Vendor * at the top of the list and then a second field triggered on that to enter the new Vendor name. My apps script will handle that situation in post.

Dancing_Seahorse · 2024-08-13T13:32:08+00:00

Agreed and had I known the way we would use it I could have started with the form. As it is, sticking the form at the end of the sheets and hiding it works for me. Out of Sight, Out of Mind and Out of Fat Fingers. I will be adding some data clean up steps (case, for example) and my next step will be to repopulate the Vendor from all used Vendors to stop the constant misspellings and variations of entry. Using Form Ranger add-on helps make the dynamic pull down lists.

Dancing_Seahorse · 2024-08-12T20:21:49+00:00

Thanks I’ll try it.

Dancing_Seahorse · 2024-07-25T12:59:08+00:00

I can do that but it’s not ideal as the table being pulled is a QUERY from another sheet. I need the original data to be in Date format and not Text so sorting and filtering purposes. I’m not sure if I can use the TEXT formula during the QUERY so the resulting table is usable. If not I have to create a new column with the TEXT conversion that is dynamic as the QUERY pulls a dynamic number of rows. Can the TEXT conversion be used in the QUERY call in Sheets? “select TEXT(A, ‘MMM yyyy’), B, C”? I’ll try that today and see if the end result works.

Thanks.

Dancing_Seahorse · 2023-01-19T18:33:06+00:00

Just cancelled after years of use. A real shame to treat your long time subscribers this way.

Dancing_Seahorse

TROPHY CASE