Delete "Empty" Fields with no Data Reference

Mazze

Hey everyone,

maybe someone can help me: I have a data base table two linked / referenced data fields on a second table. In this case the table should match "friends".
As soon as one of the friends is deleting his account there is the correct "Refernce no longer exists"-Statement.
[image.png]
Using Tasks I want to get rid of empty reference-fields over night. The question is: How do I make up the query?

I want to select all fields with "no reference" and then delete it by using a loop.
[image.png]
But i sadly cant find the correct query parameter for this field
[image.png]
Any ideas?

Michael Udinski

Hi  - here's how you can create that logic:


Alternatively, you could do some sort of cascading delete so that as soon as your parent record is deleted, your child records are deleted as well. 

Mazze

Perfect, thx 🙂

Kyan Lynch

@Michael Udinski it looks like the picture or video you originally posted isn't showing up in this new community platform. Can you link it again?

Michael Udinski

No problem @Kyan Lynch here you go:

https://youtu.be/aPvEbzR4g24

Kyan Lynch

Excellent, thank you, @Michael Udinski! Could you share more information on how to do this when the reference field is in a list format?

For example, to extend the use case from your explainer video, let's say multiple merchants are running the same deal. That is captured in the deal table by having a reference field list of multiple merchants per deal row. If one merchant is deleted, how can I remove that one reference, but leave the other references in tact in that list?

Kyan Lynch

Can anyone help me with this latest question? How do I create an API call to remove empty reference ids from a reference field list?