Workaround for Filtering Sheets / Stackby

[Kenny]

If am looking for 03, these below rows will be selected:

Then if i am looking for CRV, these below records will be selected:

What i want is CRV that has 03, as shown below:

Pabbly does not have Search record in Google Sheets or Stackby via Filter. What is the workaround for this use case?

 

[Pabbly]

If am looking for 03, these below rows will be selected:
View attachment 633

Then if i am looking for CRV, these below records will be selected:
View attachment 634

What i want is CRV that has 03, as shown below:
View attachment 635

Pabbly does not have Search record in Google Sheets or Stackby via Filter. What is the workaround for this use case?

We do have a Google Sheets Search and Lookup option. Please check the below tutorial for the same -

 

[Kenny]

The Video does not answer my question. You said in the video 5:22, that i need repeater for it. How actually it works?

 

[Pabbly]

The Video does not answer my question. You said in the video 5:22, that i need repeater for it. How actually it works?

Can you confirm if you're using Stackby or Google Sheets, please?

 

[Kenny]

Stackby

 

[Fagun Shah]

Achieved similar thing in GSheet, if it helps anyone -

 

[Kenny]

Can you confirm if you're using Stackby or Google Sheets, please?

How can i return the bundle quantity? For example: i have 3 set of data and i want to say to client that "you have 3 set of data"

 

[Fagun Shah]

How can i return the bundle quantity? For example: i have 3 set of data and i want to say to client that "you have 3 set of data"

May be by putting a counter after interator and counting how many time it went thorugh.

 

[Pabblymember11]

Hey @Kenny

Pabbly does not have Search record in Google Sheets or Stackby via Filter. What is the workaround for this use case?

We have checked the possibility to filter out the rows which are having desired values and it seems like it's not possible to filter out the data in that manner in Stackby.

Though the API brings the entire rows, which are having 1st keyword to be filtered out only.

And the second keyword which was supposed to be searched in the column wouldn't even get searched by API.

 

[Kenny]

Hey @Kenny

We have checked the possibility to filter out the rows which are having desired values and it seems like it's not possible to filter out the data in that manner in Stackby.

Though the API brings the entire rows which are having 1st keyword to be filtered out and the second keyword to get searched wouldn't even appear in response to API.

How about in Airtable?