Skip to main content
Question

Using pipeline to delete blank records in child table

  • October 11, 2023
  • 0 replies
  • 221 views

Hi There,

I am simply wondering what steps are needed in a pipeline to clear empty records from a child table.

Thanks in advance!



------------------------------
Colin Fox
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Registered
    • October 11, 2023

    The most efficient way is to use the 'Remove Record(s)' action in the QB channel: 

    You will need to actually write out the query based on what defines a child record as 'empty' though - so lets say its all records where they don't have a Project Name for example where Project Name is field ID 7 - then your query would be: 

    {'7'.EX.''} 

    //all records where field 7 is blank. 

    Be careful though, it might be worth copying the app and building the pipeline there as this purge can't be undone if you set the query wrong. You can also test to see what records that might get by copying your query like so: 

    https://realm.quickbase.com/db/your table dbid?a=q&query=insert query here

    This lets you see the records it might actually delete before you test the pipeline. 



    ------------------------------
    Chayce Duncan
    ------------------------------

    Terms & ConditionsAccessibility statement