You tell Hoofingold that you're looking for work, and ask if he has any leads.

Hoofingold: "Hmm... as an adventurer, you could try offering your assistance to one of the shopkeepers around town. Some of them might be looking for help gathering materials for their crafts, or delivering items to and from all over Equestria."

You recall that Crystal Charm was looking to buy gemstones.

Hoofingold: "Ah, well, there you go! And it sounds like quite the opportunity, don't you think? I wouldn't pass on it if I were you."

A subtle smell of baking oatmeal cookies begins to fill the room.