Skip 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 found records within a script

cknudsen01
in Script Workspace and Script Triggers

Featured Replies

I'm trying to automate deleting records from appointment database. In my script I am using copy/paste to insert the contents of a serial number field from a related database into the related field in the main database during find mode.

I want to delete any records in my main database that have that same serial number. The find part works properly, but when I try to create a loop deleting all the found records, it deletes only one. Any advice would be much appreciated! This one has me tearing my hair out!

Loop

Enter Find Mode[]

Paste [select, "serial number"]

Perform Find []

Delete Record/Request [No dialoge]

Go to Record/Request/Page [Exit after last, Next]

End Loop

Hi Christian,

There is an easy answer. It is the ScriptMaker step called Delete All Records.

Test it out on a backup till you get comfortable! tongue.gif" border="0

Good luck!

Andrew

  • Author

Thanks Andrew!

It works! I don't think I would have had the nerve to try that! Thanks a million! These things always turn out to be simple solutions.

Cheers,

Christian

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

Search

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.