Jump to content
Sign in to follow this  
john9210

Filtered value list

Recommended Posts

I have a value list that displays a fixed set of years: 2018, 2019, 2020...2030. I use it for creating new records. I've already used the years 2018 and 2019 to create records. Is there a way to filter the list so it only displays the values after 2019? Or, is there another way to do what I'm trying to do?

Share this post


Link to post
Share on other sites

Hi John

I think the issue is that you are using a value list in a situation in which it was never really intended to be used. It seems like you are only setting these records up once (since you don't want any duplication), so why have a value list? A value list is used to guide users so that they only choose valid selections when filling in a field, but your users won't be setting up records using that list perhaps?

You are probably only setting up one new record each year. Why not just type in the year when you setup a new record?

I can't think of any easy way to do what you originally asked, it would be a whole lot of effort for no big benefit.

 

Share this post


Link to post
Share on other sites

Here try to take a look at this sample file.

 

remove.zip

Share this post


Link to post
Share on other sites
Posted (edited)

You might also consider a more generic approach.  This 'on-the-fly' method of specifying global value lists is very familiar to Mr. Vodka as well.  Having this trick in your tool kit is VERY handy (attached) and would work nicely in your situation, John! 

Global_VL.fmp12

By the way, if you do need to restrict values by removing those years already assigned, you can do that as well, right within the Let() statement itself.  I wasn't clear if that was part of your need.

Edited by LaRetta
Added sentence
  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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