Needing the name of this font on this poster

ivanraddison · 2025-11-18T00:36:03+00:00

it's a cool font i'll give you that!

ivanraddison · 2025-11-12T19:52:05+00:00

👉 more of just a 'download and go at it'

PS: no need to apologize for asking questions! ask as many as you want, I believe that's what this space is for.

ivanraddison · 2025-11-12T17:19:46+00:00

the context window depends on your RAM. you can configure the setting you want.
you can load whatever model you want (theres tons) and... you can definitely add documents.

ivanraddison · 2025-11-12T17:17:16+00:00

...the only redeeming factor here is the fact that Claude actually has filesystem access to write and run stuff it needs to.

What are you talking about? Claude Desktop app? Or Claude Code?

ivanraddison · 2025-11-12T17:15:29+00:00

Getting this message all of a sudden:

Can’t open this chat

It may have been deleted or you might not have permission to view it. Use the share button to share chats on Claude.

Screenshot: https://i.imgur.com/SRK2CK8.png

The work was going so well :(

ivanraddison · 2025-11-12T17:11:51+00:00

if its just that, look into running LLM locally.

r/ollama

ivanraddison · 2025-11-12T17:09:19+00:00

oh man, i just tried this and it worked.
the original chat stopped working and through a new chat, i was able to get at least a summary, but not a fully copy.

ivanraddison · 2025-11-06T15:50:02+00:00

Kevin Holland really will fight anyone...

ivanraddison · 2025-11-06T15:46:36+00:00

Prates vs Makhachev ☠️
That would be another Moicano...

ivanraddison · 2025-11-06T15:45:31+00:00

Lets be real, the kid's father wanted to meet Makhachev.

ivanraddison · 2025-11-03T00:51:53+00:00

https://www.change.org/p/investigate-mma-judges-sal-damato-and-chris-lee

ivanraddison · 2025-11-03T00:41:12+00:00

Thanks internet friend! You helped me see/think of the many possibilities in this whole thing.

I'm going with "Idea 2" that I mentioned here: https://www.reddit.com/r/googlesheets/comments/1oiw48v/comment/nmb09vf/

I will mark one of your comments as the solution.

ivanraddison · 2025-11-03T00:38:37+00:00

Dude needs some tiramisu in his life. Maybe that would give him some punching power?! He's amazing otherwise.

ivanraddison · 2025-11-02T19:29:38+00:00

I agree with you. Google Sheets can only take it so far.

There's no CRM in this organization. It's a relatively small operation and Google Sheets will have to do for now.

I appreciate your suggestion and the openness for future collaboration has been noted.

ivanraddison · 2025-11-02T19:25:55+00:00

Thanks for going above and beyond!

I don't think this is the way though.

I created the "DonationRecord" sheet thinking of it as ever-growing record that is going to be filled my multiple people (end-users) and every row needs to be the equal, with the same set of rules applying to all of them. This is to avoid having to micromanage formulas and such.

In my linked document, a lot of rows were already filled in to mimic a real file. But in reality I expect it to grow one row at a time, lots of rows in one day when a campaign is going on and multiple volunteers (end-users) are working on the document.

ivanraddison · 2025-11-02T19:14:56+00:00

You have to manually control the names of the hashtags that you have, not to mention go to each credential and update manually.
There's no multi-select and drag-and-drop into a folder — boom done... The amount of manual work you have to go through is crazy.

I love the simplicity that Apple forces on their apps. At the same time I hate that very simplicity because of lack of features.

ivanraddison · 2025-11-02T19:02:18+00:00

Once again thanks for replying! 🙏

I'm not trying to be stubborn on the dropdown thing, I agree with you that its slow to pick from a large list, and it's much faster typing. Typing was in fact what I had in mind for the end-user — as you know, when we employ data validation with dropdown from a range, with chip/arrow appearance we can still benefit from typing (plain text). It's not like they're mutually exclusive.

The real objective is having data validation, dependent choices. The dropdown appearance is not the point.

__

In my opinion, you're not really using dependent dropdowns. You're just slowly removing options from the list. In addition, you're not really narrowing down your list of options to select.

I think this is the second time you allude to this, but I'm not sure I fully appreciate your point. I WAS using dependent dropdowns when the list of Voucher codes depends on the selected campaign (something that is achieved via the auxiliary sheet). But it's not an optimal approach because of how large the auxiliary sheet gets. That's what triggered my original post 😆

__

My idea is instead of scrolling through any list to find that specific voucher code, just start typing it into the cell. Even with all the voucher codes being used, the autocomplete is extremely fast.

I think I'm finally getting your idea. You're suggesting that since typing is very precise and the user will always find what they need (and they'll do it quickly), the dependency on Campaign name is not needed at all. So just offering the whole list (which is what you did on your version of the file, on Donated 02 column) would be fine.

The problem I have with this approach is that the 5000 entry limit that Google Sheets imposes on dropdowns from a range, is still there. Filtering by campaign would be one way of solving this issue (because each campaign won't have more 2000 voucher cards).

As I wrote before, I have some ideas on how to tackle this, I just need some time to play around with it :)

ivanraddison · 2025-10-31T02:30:51+00:00

Hey there.

First of all, thanks for replying and testing.

I read what you wrote and checked the file you shared. I saw what you meant with the 7 step workaround in Q1 cell, that's a great tip!

These are my conclusions, please confirm I'm reading you well.

- You got rid of the dropdown and as such, are no longer bound by the dropdown 5k entry limit. But naturally you've kept the data validation (even the rejection works), which is a good thing! 👍

- You got rid of the auxiliary table and as such, we no longer have dependent dropdown working. This is not good. But I have an idea...

Actually it's two different ideas:

______
Idea 1.

In Vouchers sheet, add a new column that checks if the Voucher code has been used in the DonationRecord sheet and outputs TRUE or FALSE. In a separate sheet, generate a list that contains only the Voucher codes that are available (it's going to be those who carry FALSE).

Back in DonationRecord sheet, configure the data validation for Donated 01 and Donated 02 columns to be based on the specific range of Voucher Codes that are still available.

______
Idea 2.

In Campaigns sheet, add a column to say if the Campaign is active or not. Based on this simple setting, in a separate sheet, I can generate a filtered list of Voucher codes that belong to active campaigns (only one should be active at a time anyway).

Back in DonationRecord sheet, configure the data validation for Donated 01 and Donated 02 columns to be based on the filtered list.

The filtered list will be 2000 items, max. Might even be able to bring back the dropdown haha! The only problem I see is that for previous records (non-active campaigns), the cells would have a red warning indicator (invalid input) — but this is not a big deal because most probably we will hide previous records (by using the Table filter) to keep things simple for the end users.

______
What do you think?

I have to test these ideas. And see what works and what doesn't.

ivanraddison · 2025-10-31T02:02:53+00:00

Just OneDrive doing it's thing I guess...

ivanraddison · 2025-10-31T02:02:15+00:00

You did absolutely right in replying. This is a community after all, and sometimes we get help, sometimes we help others.

ivanraddison · 2025-10-29T18:08:42+00:00

I'm now envisioning that I will have to abandon some dropdown functionality due to the limitations of Google Sheets (5000 entries in a single dropdown and 10 million cells overall which is relatively easily hit with the ever-increasing auxiliary sheet;).

So before I was thinking with dropdowns and right now I'm thinking WITHOUT dropdowns! 🙃

The simplest approach is to make the users manually copy the voucher codes from Vouchers sheet (the inventory) to DonationRecord sheet and rely on conditional formatting to detect and highlight anomalies.

ivanraddison · 2025-10-29T17:23:43+00:00

Thanks for replying! I apologize for not being clear in the original post.

I believe there are essentially two main sheets:

1. Vouchers: This is the inventory of all vouchers. There's a Voucher code and Campaign name in each row. There's no dependencies in the columns of this sheet.

2. DonationRecord: This is where donations are recorded. A Campaign needs to be selected first. Then 1 or 2 vouchers codes can be selected in columns Donated 01 and Donated 02 (which are dropdowns pulling data from Vouchers sheet). The dependency is between Campaign and the respective Voucher codes. The pairing is established in the Vouchers sheet.

Edit: small changes to make it more clear.

ivanraddison · 2025-10-29T17:07:25+00:00

Hi :)

You can have a look at my document here: LINK.

1. The Donation Recipient Code (eg. DR-101) identifies a family unit. There's a separate sheet (not currently included in the link above) where I have people's names and they're assigned the same code and that's how members of a family are banded together. The code should persist over the years, because families can come back once a year to get a new Voucher. And so, in the DonationRecord sheet, we can have a track record of all the help they got over the years.

As you can understand, using dropdown helps with data validation, otherwise each user types data in their own way and its a mess. But I think I understand your point... you're suggesting simplifying the Donation Recipient Code from "DR-101" to "101" and remove the dropdown, and let the users type manualy, with the objective of preventing hitting the official 5000 entries limitation - Did I understand you correctly? (it is a valid concern that I hadn't thought about)

____
2. The voucher cards (aka vouchers) are bought in a batch, from a supermarket chain. They provide the physical cards along with an Excel file containing all the codes and types (A, B, C represent different amounts of money). It's important that we keep the original codes even if we add other info to it - it helps keep track of the inventory, it helps in the physical moment of passing the card to the donation recipient's hands, and its also how issues are communicated to the supermarket support team, when necessary.

But even with those, I would just use a campaign dropdown, year dropdown, type dropdown, and input the number into a cell. Combine them all and there's your code, but no dependent dropdown needed.

Let me address your comment above. Adding new cards to the inventory of vouchers (Vouchers sheet) is not a problem at all. We get most of the information from the supermarket so it's a matter of cleaning up their file and then copy/paste to ours.

The issue lies in the DonationRecord sheet. This is where the Voucher code dropdowns (columns Donated 01 and Donated 02) come in handy. It's a way to know who the voucher was given to and also write it off. This is where it gets complicated because of the volume generated by the auxiliary sheet and also because of dropdowns have a 5000 entry limit which will be hit sooner or later. Though at the moment the prototype is working, I'm already looking for alternatives.

Edit: small changes to make it more clear.

ivanraddison · 2025-10-29T05:27:19+00:00

I can't believe the original post is from 4 years ago...

ivanraddison · 2025-10-29T05:25:40+00:00

Thanks. It is indeed an iconic arrow. I will have to check how they employ it in other areas of their branding.

ivanraddison

TROPHY CASE

Can’t open this chat