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.

Script auto enter data to selected record (omitted record)

Featured Replies

  • Newbies

HI All,

i am new to Filemaker, and i am not sure i post in the right Topic here.

I have the Layout list view and i have one field name "checked". I have create a edited box with global field named. I need help that when i type "Check" in global field and run script then selected or ommitted record will fill data "Check" to all the record in field name "Checked". 

Thanks for any help very much

Why would you want to do this on a regular basis? This sounds like you have a deeper problem and you are trying to address one of its symptoms.

Technically, if you have a global field named gValue and a Text field named Checked, then this script step;

Replace Field Contents [ YourTable::Checked; Replace with calculation: YourTable::gValue ]

will place the globally held value into the Checked field in all records in the current found set, except records that are locked by other users. This (locking by other users) is the reason why Replace Field Contents[] is normally reserved for situations like imported data cleanup - which is done once and while the current user is the only user that will access the records.

There is no way to manipulate omitted records. If you want to include them, you must do Show All Records[] first.

 

Edited by comment

  • Author
  • Newbies

Thanks comment for helping. It works for me now. Next time I should check Filemaker formula before posting here. The reason i doing this because i have to check every single entry record in the right name.

Again thanks you very much

 

Create an account or sign in to comment

Important Information

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

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.