nocodb
The core issue is that despite successfully creating new records in two NocoDB tables (People and Company) using Typebot, and correctly identifying the specific Company record to update using its unique ID, the relational field ("People Link") in the "Company" table is not being updated to link to the corresponding "Person" record.
Here's a breakdown of the problem:
Successful Record Creation: Typebot successfully creates new records in both the "People" and "Company" tables in NocoDB.
Correct Company Record Identification: The Typebot "Update Existing Record" action correctly finds the target "Company" record using its unique ID.
Failure to Update Relational Field: The "People Link" field (a "Links to another record" field in the "Company" table that should point to the "People" table) is not being updated with the person_id_nocodb.
Text Field Updates Work: Typebot can successfully update regular text fields in the "Company" record, indicating the connection and basic update mechanism are functional.
Suspected Cause: The problem likely lies in how Typebot is formatting and sending the person_id_nocodb value for the relational field. NocoDB's API expects an array of IDs for relational fields, but the direct ["{{person_id_nocodb}}"] format in Typebot's "Value" field isn't working, OR Tyebot cannot update a relational field in NocoDB.
My troubleshooting has focused on finding the specific syntax or method that Typebot's NocoDB integration requires to correctly format the linked record ID as a JSON array string for the relational field update, but I don't actually know if this is ultimately even a feasible function in Typebot...
Here's a breakdown of the problem:
Successful Record Creation: Typebot successfully creates new records in both the "People" and "Company" tables in NocoDB.
Correct Company Record Identification: The Typebot "Update Existing Record" action correctly finds the target "Company" record using its unique ID.
Failure to Update Relational Field: The "People Link" field (a "Links to another record" field in the "Company" table that should point to the "People" table) is not being updated with the person_id_nocodb.
Text Field Updates Work: Typebot can successfully update regular text fields in the "Company" record, indicating the connection and basic update mechanism are functional.
Suspected Cause: The problem likely lies in how Typebot is formatting and sending the person_id_nocodb value for the relational field. NocoDB's API expects an array of IDs for relational fields, but the direct ["{{person_id_nocodb}}"] format in Typebot's "Value" field isn't working, OR Tyebot cannot update a relational field in NocoDB.
My troubleshooting has focused on finding the specific syntax or method that Typebot's NocoDB integration requires to correctly format the linked record ID as a JSON array string for the relational field update, but I don't actually know if this is ultimately even a feasible function in Typebot...
