BUG REPORT Airtable 2.0 Search Record is missing critical field

Status: Closed · Asked by Blue Li on · 0 views

blueli — Question ·

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.09 PM.png
Arshil Ahmad — Reply ·

Hi @blueli,

Please allow us some time to look into this concern. We will get back to you with an update soon.

Arshil Ahmad — Reply ·

Please try using 'Search Record by View' action event to get the Field ID and Search Value.

Fagun Shah — Reply ·
Please try using 'Search Record by View' action event to get the Field ID and Search Value.

But then what is the point of Search Record action Shouldn't that have Field Name and Search Value fields Please confirm with your developers.
Fagun Shah
- Automation Freelancer
- Let's Connect - https://www.facebook.com/fagun.shah.7/
Pabblymember11 — Reply ·

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({field_name})), CONCATENATE("^",LOWER(ENCODE_URL_COMPONENT("search_value")),"$"))

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.

Fagun Shah — Reply ·
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({field_name})), CONCATENATE("^",LOWER(ENCODE_URL_COMPONENT("search_value")),"$"))

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.


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.

Fagun Shah
- Automation Freelancer
- Let's Connect - https://www.facebook.com/fagun.shah.7/
Pabblymember11 — Reply ·
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 — Reply ·
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.
Fagun Shah
- Automation Freelancer
- Let's Connect - https://www.facebook.com/fagun.shah.7/
Pabblymember11 — Reply ·

I've duly noted your input and will pass it along to the team.

Fagun Shah — Reply ·

@Supreme @blueli @ArshilAhmad this is solved now. Search Record action now have necessary fields, just like old action.

Fagun Shah
- Automation Freelancer
- Let's Connect - https://www.facebook.com/fagun.shah.7/

Back to all forum threads · Log in to reply