I have a system for users to “donate” a virtual currency to each other for the purposes of “spending” on things. I’m running into an issue. I want to allow User A to “donate” money to User B and have the donation be recorded in “Donation Made” column in User A’s row, containing data “donation amou…

Ok I have a prototype for you. [CleanShot 2025-03-01 at 11.38.00] I’m simulating your data like this. In theory, as you’re storing it as an array, you need a joined list column to join them together first, and then a template column to wrap it in brackets. [ J ] With J being the joined JSON men…

Yes, it’s possible. To clarify, the user table have number columns with a raw value of “donation made” and “donation amount” but also another column of an array of these items as a “donation log” of sorts? Before fleshing out the solution, is there a reason why you’re not just logging the donations…

I had already thought about creating another table/big table as a “donation ledger” and rolling up the results, but I don’t want to eat away at my row allocation. This app I’m developing will be used by over 1000 people concurrently, each making multiple donations throughout a week-long program, an…

I recommend using JSON. Here’s a tutorial that uses restaurant orders as an example, but the process is similar: [image] dizzyaccordion JSON Trebuchet Community Resources wave Hey fellow Gliders! Part two of my Trebuchet series is live! Last week, I posted a t…

This was actually very helpful! I am now able to get the values submitted such that each individual donation creates a 3-piece “Donor, value, recipient” JSON object and stores all of those individual objects inside one cell. But I’m having trouble figuring out how to then separately query this so …

Yes, you’ll need to pull them apart using a helper table. I think the video goes into that no?

Yes, but I’d rather not have to use a second table. The app I’m making will have around 1000 users making anywhere from 0 to n donations so coming up with a helper table would be pretty big and complicated. I was thinking that I could try to make a Query JSON column that could check the Donations …

The idea should be joining all JSON elements in an array. Then, use JSONata with dynamic querying template to query out what you need. It should be possible, but it’s complicated.

So then the next question I have: how do I create a JSON Query that pulls a value from one column (“UserID”) and runs a lookup on a JSON Object?

Can you show me a sample of the JSON object you have, and an ideal outcome you want from that JSON object? In each row, I assume you’re having a list of all donations that the person has made?

Let’s say I have { “UserID”: 12345 } as my object. I want to run a Query that calls UserID as the lookup criteria from an adjacent column in the same row and return 12345 as the result.

User submits value, gets added as an array element to their column

Ask for Help

Robert_Petitto February 25, 2025, 6:36pm 4

I recommend using JSON. Here’s a tutorial that uses restaurant orders as an example, but the process is similar:

Topic		Replies	Views
Items in Array to separate row in another table Ask for Help	17	223	March 17, 2025
Is it possible to split Individual elements of JSON query into separate rows in different table? Ask for Help	3	165	March 18, 2025
Order that data appears Ask for Help	16	306	March 13, 2021
Is there a way we can save the results of a query column to another column? Ask for Help	2	46	January 31, 2025
Turn JSON array into rows in separate table Ask for Help	12	248	August 10, 2025

User submits value, gets added as an array element to their column

Related topics