malagasy Posted February 23, 2007 Share Posted February 23, 2007 Hi, I have a drop down list in my invoice section that allows me to select the day the service will be provided. The drop down list takes the data from a field called Date and i would like the drop down list to only show the dates that has yet to come. For example, I have 52 entries in this date field which are the 52 saturdays of the year. we are 23rd feb so i would like the drop down list to show only the saturdays to be coming and not the ones that already happened... Is there a way of doing this ? I'm quite unexperienced so i would appreciate an English version of the things to do ! :-) Regards. Link to comment Share on other sites More sharing options...
RT Posted February 23, 2007 Share Posted February 23, 2007 i am not experienced enough to tell you what to do but you may be interested in this thread. it may point you in the right direction. http://fmforums.com/forum/showtopic.php?tid/179235/ Link to comment Share on other sites More sharing options...
RodSierra Posted February 23, 2007 Share Posted February 23, 2007 If you already have the dates in a field, I think that's how I understand it create a calc field: Case ( Date ≥ Get ( CurrentDate ) ; Date ; "") Base your value list off that field. Rod Link to comment Share on other sites More sharing options...
Genx Posted February 23, 2007 Share Posted February 23, 2007 (edited) This is a potential way of displaying only future saturdays, though i'm not sure what you have against the calendar. dateExample.zip Edited February 23, 2007 by Guest Link to comment Share on other sites More sharing options...
malagasy Posted February 28, 2007 Author Share Posted February 28, 2007 I like your solution Genx but unfortunately, it doesn't seem to be working for a portal. Sorry, I should have been more precised ! Indeed, my services are given over 5 or 10 saturdays in a row. 1 / In the drop list that will be in the portal, I only want the upcoming saturdays. 2/ Also, is there a way so the portal automatically enter the 4 or 9 other saturdays by itself in the portal ? Cheers. Link to comment Share on other sites More sharing options...
mr_vodka Posted February 28, 2007 Share Posted February 28, 2007 How about something like this. dateExample2.zip Link to comment Share on other sites More sharing options...
malagasy Posted March 1, 2007 Author Share Posted March 1, 2007 This exemple given by Mr_vodka seems to be good for automatically enter data in the portal but can't do much about the drop list date problem Link to comment Share on other sites More sharing options...
mr_vodka Posted March 1, 2007 Share Posted March 1, 2007 What exactly is the issue. the drop down list displays what you asked for. It displays 52 saturday dates. Link to comment Share on other sites More sharing options...
malagasy Posted March 1, 2007 Author Share Posted March 1, 2007 I'd like the drop down list to only show the UPCOMING saturdays, not the ones that already have gone. Link to comment Share on other sites More sharing options...
mr_vodka Posted March 1, 2007 Share Posted March 1, 2007 I still dont understand. The drop down only displays the saturdays that begin with this coming saturday Mar 03, 3007. There is no past saturdays... Link to comment Share on other sites More sharing options...
malagasy Posted March 1, 2007 Author Share Posted March 1, 2007 of course it displays the upcoming saturdays but it won't be the case in the weeks coming. I should have been clearer, sorry, i'm trying to have something dynamic. ie: let's say we are 26th march, i don't want the previous weeks to appear...son on and so forth. Thanks for your help John and the others Link to comment Share on other sites More sharing options...
Genx Posted March 1, 2007 Share Posted March 1, 2007 Why do you think it doesn't work in a portal? dateExample.zip Link to comment Share on other sites More sharing options...
mr_vodka Posted March 1, 2007 Share Posted March 1, 2007 This sunday (mar 4th), the drop down list will change so that it will only show values starting from Mar 10th, 17th, 24th, etc. Link to comment Share on other sites More sharing options...
malagasy Posted March 1, 2007 Author Share Posted March 1, 2007 Genx > this solution is working however when I try to apply it to my database, the drop list is empty. Can you explain what I should be looking at in this case and why it doesn't work. Thanks Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6266 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now