Hi ,
I am using the API.
When a user creates a new row in the UI, either using the new row icon (+) or via the duplicate row routine, on receipt of the webhook created event, I immediately update the new row with “skeleton” data using: patch(‘… database/rows/table/[table_id]/[row_id]/?user_field_names=true’),
The purpose of returning “skeleton” data is to prepare the row for user input. Part of this process is to clear down some text, dates, dropdowns and table links, forcing the to change columns to the appropriate value (especially when duplicate is used).
However, when trying to update formatted columns to a NULL/Blank value, the API returns an error.
For example I have a table columns:
Name (type single line text)
Quote Date (type date ISO)
Projects (type link to project table)
Project Status (type single select)
Completion % (Type formula)
when I patch one/some or all of the columns below with a blank (“”) or NULL value, the API returns an error.
Quote Date:“”
Projects:“”
Project Status:“”
Completion %:“”
when I patch (below), the API returns success
Name:“”
Please can you advise on how set formatted columns to NULL or blank?