fomatting a field to show result from value list

[fishbone]

I have a pop up menu that uses a value list: "1 Day, 1 week, 1 month, 3 months, exact date".

These are the values for the next call to be made under the "call menu" field.

Let's say I choose "1 week." When i click that pop up menu and choose "1 week" i want a different field ("next call") to display the result of the current date + 7 days.

Let's say i choose "3 months." When chosen, i want the "next call field" to display the current date + 3 months.

Let's say i choose "exact date." I want to perform my "next call" script which uses an input field to specify the exact date.

[color:"blue"] How do i do this? where do i define these things? what date calculations do i use?

Your help is appreciated, Thanx.

[fishbone]

I have a pop up menu that uses a value list: "1 Day, 1 week, 1 month, 3 months, exact date".

These are the values for the next call to be made under the "call menu" field.

Let's say I choose "1 week." When i click that pop up menu and choose "1 week" i want a different field ("next call") to display the result of the current date + 7 days.

Let's say i choose "3 months." When chosen, i want the "next call field" to display the current date + 3 months.

Let's say i choose "exact date." I want to perform my "next call" script which uses an input field to specify the exact date.

[color:"blue"] How do i do this? where do i define these things? what date calculations do i use?

Your help is appreciated, Thanx.

[fishbone]

I have a pop up menu that uses a value list: "1 Day, 1 week, 1 month, 3 months, exact date".

These are the values for the next call to be made under the "call menu" field.

Let's say I choose "1 week." When i click that pop up menu and choose "1 week" i want a different field ("next call") to display the result of the current date + 7 days.

Let's say i choose "3 months." When chosen, i want the "next call field" to display the current date + 3 months.

Let's say i choose "exact date." I want to perform my "next call" script which uses an input field to specify the exact date.

[color:"blue"] How do i do this? where do i define these things? what date calculations do i use?

Your help is appreciated, Thanx.

[comment]

The calculation for next call is:

Case (

call menu = "exact date" ;

input field ;

Choose ( Length ( call menu ) - 5 ;

Get ( CurrentDate ) + 1 ;

Get ( CurrentDate ) + 7 ;

Date ( Month ( Get ( CurrentDate ) ) + 1 ; Day ( Get ( CurrentDate ) ) ; Year ( Get ( CurrentDate ) ) ) ;

Date ( Month ( Get ( CurrentDate ) ) + 3 ; Day ( Get ( CurrentDate ) ) ; Year ( Get ( CurrentDate ) ) )

)

)

Note that this works on the basis of "1 Day", "1 week", "1 month" and "3 months" being 5, 6, 7 and 8 characters long. If you change these values, you will have to spell out the options in the Case() function.

Regarding running a script after choosing "exact date" - I believe on Windows you can do this without a plugin. This has been covered here before, so do a search for it.

[comment]

The calculation for next call is:

Case (

call menu = "exact date" ;

input field ;

Choose ( Length ( call menu ) - 5 ;

Get ( CurrentDate ) + 1 ;

Get ( CurrentDate ) + 7 ;

Date ( Month ( Get ( CurrentDate ) ) + 1 ; Day ( Get ( CurrentDate ) ) ; Year ( Get ( CurrentDate ) ) ) ;

Date ( Month ( Get ( CurrentDate ) ) + 3 ; Day ( Get ( CurrentDate ) ) ; Year ( Get ( CurrentDate ) ) )

)

)

Note that this works on the basis of "1 Day", "1 week", "1 month" and "3 months" being 5, 6, 7 and 8 characters long. If you change these values, you will have to spell out the options in the Case() function.

Regarding running a script after choosing "exact date" - I believe on Windows you can do this without a plugin. This has been covered here before, so do a search for it.

[comment]

The calculation for next call is:

Case (

call menu = "exact date" ;

input field ;

Choose ( Length ( call menu ) - 5 ;

Get ( CurrentDate ) + 1 ;

Get ( CurrentDate ) + 7 ;

Date ( Month ( Get ( CurrentDate ) ) + 1 ; Day ( Get ( CurrentDate ) ) ; Year ( Get ( CurrentDate ) ) ) ;

Date ( Month ( Get ( CurrentDate ) ) + 3 ; Day ( Get ( CurrentDate ) ) ; Year ( Get ( CurrentDate ) ) )

)

)

Note that this works on the basis of "1 Day", "1 week", "1 month" and "3 months" being 5, 6, 7 and 8 characters long. If you change these values, you will have to spell out the options in the Case() function.

Regarding running a script after choosing "exact date" - I believe on Windows you can do this without a plugin. This has been covered here before, so do a search for it.

[fishbone]

thanx, i am gonna try this first thing in the morning, i will let you know if i run into any problems

[fishbone]

thanx, i am gonna try this first thing in the morning, i will let you know if i run into any problems

[fishbone]

thanx, i am gonna try this first thing in the morning, i will let you know if i run into any problems