How to display Google sheet row data against perticualr value in column

App Building
,
1

Hey,
I am trying yo create an order ID tracker for my customers. All these customers have Order ID and have certain updated in rows.

How can I get these values against each order?
I have created an UI to show the value here
[Retool](https://TOOL UI)

I am not abel to get data agains each value from google sheet. Any help, Idea and hits to get start will be great.

2

Hi @ASHIRWAD_RASTOGI,

Thanks for reaching out! The url is not accessible to me; are you able to share some screenshots instead?

If you're trying to query data from two different data sources (i.e. database and google sheets), you might find the Query JSON with SQL query type helpful

3

Hey Tess

I have made the link public

https://castmymemory.retool.com/embedded/public/3c7f9df7-6e2a-4c47-a119-136040cb7335

Plse help in this

4

Hi @Ashirwad_Rastogi

The link has a blank app for me :thinking:

It might be more helpful to see some screenshots of what you're working on if you're able to share!

5

Are the customers providing an order ID in the app? Are you then filtering a full dataset for the specific order ID? A Javascript transformer might help!