# Delete the data from a table of a dating application

**URL:** <https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993>\
**Category:** Ask for Help\
**Created:** [February 26, 2022, 1:19pm UTC](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993 "2022-02-26T13:19:00Z")\
**Posts on this page:** 10\
**Page:** 2

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 27, 2022, 2:17pm UTC](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993/21 "2022-02-27T14:17:56Z")

</div>

hehe, one of my earliest coding experiences was in the late 70’s - I had a part time job at a Tandy store during the school holidays and I figured out how to program a welcome banner on one of the [TRS-80’s](https://en.wikipedia.org/wiki/TRS-80) on display in the store 😂

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [February 27, 2022, 4:59pm UTC](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993/22 "2022-02-27T16:59:24Z")

</div>

> [@Jeff\_Hager](#):
>
> So, the trick is really to delete the row through a single relation, but make sure that the single relation only relates to rows with dates that have already passed.

I have often thought about ways to delete orphaned records – child records left behind when the main record is deleted. I am going to try and apply this method there – on the child record, set up a relation to the main record, and if the relation is empty, delete the row.

Thanks!

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [February 27, 2022, 10:23pm UTC](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993/23 "2022-02-27T22:23:58Z")

</div>

> [@Jeff\_Hager](#):
>
> I agree and wouldn’t consider it normal to execute a function like this by exploiting another function called by a user’s interaction with the app

So, in practice, what I found out today by implementing it as a way to delete orphaned records, it doesn’t work very well if you have row owners implemented, as the only records that will be surreptitiously deleted by a user perusing his own records are records that he owns.

So going to have to look further for a solution unless there is a way to tell a relation to ignore ownership.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 27, 2022, 10:36pm UTC](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993/24 "2022-02-27T22:36:45Z")

</div>

No, if you have row owners in use, then only the owned rows will be sent to the user’s device and as such, only the rows that are accessible are the only ones that can be deleted.

> [@David\_Gabler](#):
>
> unless there is a way to tell a relation to ignore ownership

If glide could ignore row ownership, then it wouldn’t be a very secure security feature, would it. 😉

Remember, the relation is building on the user device, as well as the actions being performed on the user device. For the relation to find matching rows, that data has to be sent to, and exist, on the user device. Circumventing the security of row owners by sending unowned rows to a user device would open you up to a security breach. At that point, you’d be better off just not using row owners in the first place.

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [February 28, 2022, 1:38am UTC](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993/25 "2022-02-28T01:38:03Z")

</div>

> [@Jeff\_Hager](#):
>
> If glide could ignore row ownership, then it wouldn’t be a very secure security feature, would it. 😉

Yes, but in this app security is not the issue. Deadbeat users is the issue. I cannot count on someone who’s not even using the app to use this method to delete unused or orphaned rows.

That said, I may re-think my ownership to do what I’ve done in some tables, where I have dual-ownership via the little Google Sheet array trick. That way I can have an admin user owner of all rows and as he uses the app it will do cleanup.

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [March 1, 2022, 3:21am UTC](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993/26 "2022-03-01T03:21:59Z")

</div>

Hi Jeff, in your application, I noticed something odd happened to the formula sin(), cos(), or tan().

 ![Screenshot 2022-03-01 101720](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/3/535a6d9e9d16cf241e65d49e1d9058a07b94b361.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 1, 2022, 3:34am UTC](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993/27 "2022-03-01T03:34:18Z")

</div>

What’s odd about it? I get the same result on several other calculators.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b624b583d0f12e8fe86857a045a5759373686320.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/458b9917f3611411196ef52b985eede28c18977f.jpeg)

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [March 1, 2022, 3:36am UTC](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993/28 "2022-03-01T03:36:36Z")

</div>

Pardon me, I thought it was in degrees, it turned out to be radians. 🙃

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 1, 2022, 3:42am UTC](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993/29 "2022-03-01T03:42:38Z")

</div>

Yep, it is. I think that’s the default for glide math.

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [March 1, 2022, 3:47am UTC](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993/30 "2022-03-01T03:47:31Z")

</div>

Nice app. 💚 💚

[Previous page](https://community.glideapps.com/t/delete-the-data-from-a-table-of-a-dating-application/38993.md?page=1)
