Clearing a merge field?

Question

Wondering if anyone has ever cleared a merge field in a child table?

Based upon reference below, we can UPSERT to a child table using a merge field as the surrogate key and the relationship is made (the related parent record id# values are filled in on the child record). Now I am trying to break the relationship so the related value is empty after upsert using the merge field. I have tried 0, "", nil, null and nothing happens.

Any ideas are appreciated.

Reference below:

Link related data by importing into lookup fields

Builders now have an easier way to import records with related data or link related data in integrations. Now, any lookup field marked unique on the parent table can be used to match instead of reference fields.

RESTful Upsert Records—Users can UPSERT data to lookup fields marked unique in the data array in Record Upsert. https://helpv2.quickbase.com/hc/en-us/articles/31900230487700-Quickbase-November-2024-Release-Notes

maria · Answer

Do you mean using a pipeline?&nbsp;https://help.quickbase.com/docs/use-jinja-in-quickbase-pipelines At the very bottom of the Jinja FAQ you'll see this:&nbsp;
Solution: 
use template value {{CLEAR}} to clear a field, this is not bold in the rendered value.

Forum Discussion

Clearing a merge field?

1 Reply

Related Content

Merge Imports

Merging 2 Fields into a Formula-Text Field for Reporting Purposes

Snapshot Fields

Clear contents of Logged Approval Field

Clearing a formula date field