Hi,
I want to pass the three values from one form to another form, using URL, and query_string field. But I dont know how to write the script for that.
I want to pass empid, year and month, for these three fields pls post the script. Pls yaar I am in tension.
Hope soon
Rajan
Subject: Script required, pls help
Put this formula in some action button of first form:@URLOpen(“//?OpenForm&EMPID=” + empid + “&YEAR=” + year + "
&MONTH=" + month)
In second form use this formulas to get related values:
@URLQueryString(“EMPID”)
@URLQueryString(“YEAR”)
@URLQueryString(“MONTH”)
Best Regards,
Dima Pechersky
Subject: RE: Script required, pls help
Hi Dima,Thank u very much. Its working. But I am facing little bit problem.
Actually I am passing three values empid, month, and year to other form. Then from query_string, I am extracting these three values to another 3 text fields (hidden fields). Using these 3 fields, I am sending these three to the other database, and getting dates into $list field.
Now what I am doing that I am selecting one date from the $list field, and then sending to the other datbase, to fetch some related values.
Here is the main problem, once I send the date value to the other database, I am getting the values, but due to refreshing , the dates are not displaying in $list field. But I want to send one by one dates, to get the values.
For this please give ur suggestion. Waiting with tensionious.
Hope soon
Rajan
Subject: RE: Script required, pls help
Hi Rajan,
I’m think that reason is losing of URL parameters sent by previous form.
When you open this form at first time your URL include all three items. After reload they gone and you get sequnce number &Seq=1
Try to set three items (empid, month, and year) to be “computed on compose”
Best Regards,
Dima Pechersky