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.

Copying Check Box Data

Niet32
in Value Lists

Featured Replies

I have a script that copies data from a text field that is setup as a checkbox.

The checkbox pulls values from another table.

However, when the script copies the data from the field is not only copies the checked data but any data that is currently in the field and previous data.

For example:

X Choice 1

X Choice 2

O Choice 3

The script will copy not just the 2 items checked but all 3. It then also copies any choices that may no longer be in the database.

Running FMP 11 Advanced

Any help is appreciated.

Thanks

This sounds like a relational issue. If your table has bad Structure, then you have all sorts of data problems. may i suggest posting a copy of your Relational Graph/ Or Database WITHOUT DATA!!

cheers,

-i

I have a script .....

Explain your field setup for the checkbox and what your script is doing or provide an example of your database.

Edited by Lee Smith
If you are not going to inline comment, please Do Not Quote the entire post

  • Author

Thanks for your feedback. Something you said made me go back and relook.

I changed the field to a global field and it resolved the copying issue.

Thanks

Create an account or sign in to comment

https://fmforums.com/topic/83459-copying-check-box-data/
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.