Populating variable with data from two queries

Queries and Resources
1

Hi :wave:

I have a pretty weird situation that I can't seem to figure out...

I have two queries (one users from our DB on firebase, and another users from our CRM) that I want to combine/transform and display in one table.

Now I've managed to do it using a transformer which works great :pray:

But since firestores' pricing is based on reads no. if every time I manipulate the data it will reload all the profiles it will be pretty expensive... :grimacing:
So what I wanted to do is to store the result of the transformer in a variable, and just keep it updated. This way I only load the profiles from the firestore when the page loads.

But I couldn't find a way to set the value of the transformer into a variable... :man_shrugging:

Any ideas on how to do this?
Thanks a lot in advance :pray: :cherry_blossom:

2

Hey @Alex_Zak!

Have you already explored using JavaScript query instead of a transformer? Something like:

const [firestoreData, crmData] = await Promise.all([firestoreQuery.trigger(), crmQuery.trigger()]);

/*
put your transformer code here
*/

yourTempstate.setValue(combinedData);
3

Thanks, this worked :pray::ok_hand:

4