Jump to content

Drop down list with date


malagasy
 Share

This topic is 5698 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

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

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

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

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

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

This topic is 5698 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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