URL fields returned "INVALID_VALUE_FOR_COLUMN” error
Hi there.Can you help us solve this issue?After generating the GoogleDrive URL in GAS, we update certain fields in airtable API.The field type is “URL”.The code is below. I have already confirmed that the API URL, PAT, GoogleDrive URL and field name I am calling are correct. const drive_url = "https://drive.google.com/drive/folders/" + folder.getId();
const url = "https://api.airtable.com/v0/XXX(appID)/XXX(TableName)/XXX(recordId)"
const options = {
'method': 'PATCH',
'headers': {
'Authorization': 'Bearer ' + "XXX",
'Content-Type': 'application/json',
},
'payload': JSON.stringify({
'fields': {
'Field1': drive_url,
}
})
};
const response = UrlFetchApp.fetch(url, options);Then the following error is returned. {“type”: “INVALID_VALUE_FOR_COLUMN”, “message”: “Field \”Field1\“ cannot accept a value because the field is computed”}}However, the field type of Field1 is "URL", a
