Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Deleting multiple records

proton
in Other Internet Technologies

Featured Replies

I have a link on a page that finds a group of records. What I want to do is on finding these records I want to provide a link that will delete all of them. Now I'm not sure Filemaker allows you to do this in CDML. I'm thinking maybe I should set the link to activate a script to do it, but I would prefer to use CDML to delete it. Now I find it kinda weird that they didn't give you a delete all option in CDML. Dangerous? yes...but useful. Please advise. Thanks

I know of no way to delete multiple records with CDML. A script would be the only way to do it.

Before setting this up I'd recommend that password security be put on the database. And a regular backup regime (I'm not kidding).

A thought just occurred: it could be done with related files if the relationship was set up to allow deletion of related records. Delete the master record and all the related records will hit the bit bucket automatically. The usual disclaimers about the dangers of self-join relationships apply here.

  • Author

quote:
Originally posted by Vaughan:

I know of no way to delete multiple records with CDML. A script would be the only way to do it.

Before setting this up I'd recommend that password security be put on the database. And a regular backup regime (I'm not kidding).

A thought just occurred: it could be done with related files if the relationship was set up to allow deletion of related records. Delete the master record and all the related records will hit the bit bucket automatically. The usual disclaimers about the dangers of self-join relationships apply here.

Hmm...using the delete related records option. Sounds like a viable option. I'll check it out. Thanks for the heads up Vaughan.

Create an account or sign in to comment

https://fmforums.com/topic/5071-deleting-multiple-records/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.