• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

BUG REPORT Airtable 2.0 Search Record is missing critical field

Status
Not open for further replies.

blueli

Member
The updated one missing the search value and field ID field.
Please check
thanks
 

Attachments

  • Screenshot 2024-02-15 at 8.06.01 PM.png
    Screenshot 2024-02-15 at 8.06.01 PM.png
    293.1 KB · Views: 17
  • Screenshot 2024-02-15 at 8.06.09 PM.png
    Screenshot 2024-02-15 at 8.06.09 PM.png
    253.1 KB · Views: 19

Supreme

Well-known member
Staff member
Hey @blueli @Fagun Shah

The Search Record action step on the platform has been designed with an advanced approach, requiring dedicated formulas for searching records.

To achieve precise results, you can consult the provided screenshot and utilize the formula provided to retrieve the desired data accurately, utilizing the specific field created in your Airtable account.

REGEX_MATCH(LOWER(ENCODE_URL_COMPONENT({[B]field_name[/B]})), CONCATENATE("^",LOWER(ENCODE_URL_COMPONENT("[B]search_value[/B]")),"$"))

In the "field_name" parameter, input the name of the field where you wish to search for data values, ensuring an exact match with the value available in that particular field.

image (1).png
 

Fagun Shah

Well-known member
Hey @blueli @Fagun Shah

The Search Record action step on the platform has been designed with an advanced approach, requiring dedicated formulas for searching records.

To achieve precise results, you can consult the provided screenshot and utilize the formula provided to retrieve the desired data accurately, utilizing the specific field created in your Airtable account.

REGEX_MATCH(LOWER(ENCODE_URL_COMPONENT({[B]field_name[/B]})), CONCATENATE("^",LOWER(ENCODE_URL_COMPONENT("[B]search_value[/B]")),"$"))

In the "field_name" parameter, input the name of the field where you wish to search for data values, ensuring an exact match with the value available in that particular field.

View attachment 38447
This is no where near to user friendly.

Can you please ask developers why they removed the fields for Field Name and Search Value ?

Both were already present in old action, Airtable only changed the authorization process, so I don't understand why pabbly team is removing absolutely necessary fields. This will only make users come your support team again and again and increase load for you. In its current stat it is not usable for new users. Please bring back those fields.
 

Supreme

Well-known member
Staff member
Can you please ask developers why they removed the fields for Field Name and Search Value ?

Both were already present in old action, Airtable only changed the authorization process, so I don't understand why pabbly team is removing absolutely necessary fields. This will only make users come your support team again and again and increase load for you. In its current stat it is not usable for new users. Please bring back those fields.
Our team is already working on the optimization of the Airtable action step for ease of use. They are trying to make it more user friendly. But for now, you may use the provided solution.

We will keep you posted with the updates.
 

Fagun Shah

Well-known member
Our team is already working on the optimization of the Airtable action step for ease of use. They are trying to make it more user friendly. But for now, you may use the provided solution.

We will keep you posted with the updates.
I am waiting for the updates, currently I can't keep asking you to write regex for me for each Search Record action step.
 
Status
Not open for further replies.
Top