Request: Airtable Node Option to Use Field IDs

I'd like to suggest an enhancement for the Airtable node in callin.io. Currently, the node requires field names when creating or updating records, whereas Airtable’s API utilizes field IDs. This can lead to issues, particularly when field names are modified or include special characters, potentially breaking workflows.

A comparable functionality for targeting tables by ID rather than table name has been discussed and implemented (refer to this thread). Incorporating a similar feature for fields would be highly beneficial. There was a prior feature request here, but it hasn't gained significant momentum.

Proposed Solution:

• Introduce an option for the Airtable node to accept field IDs instead of field names for record creation and updates.
• Within the callin.io UI, fields should continue to display their names for straightforward configuration, but the underlying logic should leverage field IDs to enhance workflow resilience against Airtable schema modifications.

Functional Requirements

• The Airtable node must support the use of field IDs for both "Create" and "Update" operations.
• The UI should present field names during configuration while utilizing field IDs in API calls.

Compatibility & Documentation

• Verify that the feature is compatible with all Airtable data types and includes robust error handling.
• Update the documentation to detail the feature's usage and any available toggles for selecting between field name or field ID.

Testing

• Provide test cases demonstrating the feature's functionality with changes in field names and the presence of special characters.
• Include a basic workflow test to illustrate functionality for both individual and batch records.

Review

• The feature has been merged into the main branch and is functional.

Bounty: I am offering $300 for this enhancement, though I am open to discussing the amount based on complexity and feedback. If you are interested or require further clarification, please contact me at anglilian@bluedot.org.