Qrew Tip: Pipeline Null Values

Master technical support rep TeodoraSto​ shows us a simple solution to a rather common (if somewhat obscure) Pipeline hiccup.

Want to explore more on your own? 

Here are some additional resources to check out.

• Clear the value in a field
  https://help.quickbase.com/docs/transforming-your-data#clear-a-field-in-an-update-pipe
  Pipelines ignores fields with empty values to avoid clearing a remote field accidentally. If you want to clear this field in an Update pipeline, you'll need to specify the value {{CLEAR}}.
  
  

• Use Jinja in Quickbase pipelines
  https://help.quickbase.com/docs/use-jinja-in-quickbase-pipelines
  
  

• Transform your data with Jinja
  https://help.quickbase.com/docs/transforming-your-data

  • Numeric calculations and conversions

  • If-Then-Else statements using code
  • Adding tags to a list field
  • Transform text
  • Manage HTML data
  • Summarize search results into a single field