Jump to content
peterstroh

Custom value lists split into 2 value lists due to character limit

Recommended Posts

Hello,

I want to split a custom value list into two lists while keeping my records intact. I used to add new vendors to a custom value list called _vendors_. I have now reached the 30000 character limit. I have managed to solve the 30000 character limit on custom value lists by splitting them into two list (_vendors_A-K and _vendorrs_L-Z) following these steps https://community.filemaker.com/thread/93937. Problem is that since I changed the value list _vendors_ into two new lists the records don't remember their old custom value meaning I would have to change over 4000 records by hand. Is there an easier way to solve this I might have overlooked? Excuse my lack of terminology, I'm new to Filemaker.

I would appreciate any comments or help

Peter Stroh

Share this post


Link to post
Share on other sites

Managing that many values using a value list does not sound fun. I'd recommend creating a table for the vendors. You could then create a value list based on the table.

However, it's also not fun to scroll through long value lists. I'd suggest you create a pick list instead. For example:

https://filemakerhacks.com/2011/05/09/popup-pickers/

http://www.modularfilemaker.org/?s=pick

Welcome to the forums!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×

Important Information

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