Hi

I need a script to let me set a value list field in a loop, search related records and save it as excel.

I don't know how to write the script. any help?

Nader

...set a value list field...

Not sure what you mean by that.

1) a value list is just a list of values

2) fields are fields

If you refer to a field that is formatted as a menu, list, check boxes or radio buttons, then it's still just a field. Just enter the value into it with the Set Field[] step.

Say you have a check box field "active". To search for all records with the checkbox selected, search for the text "active" in it. If you want to search for the field unselected, search for empty "=".

Many thanks for reply,

I think I explain my problem in a bad way. I have table with two field. 1- name and 2- date. anytime any nurse came to visit my grand mother, I enter his/her name and visited date in a record. at the end of the month i need a separate list of each nurse and the number of days that he or she visited my GM. I try to write a script to make the list and export them as excel file for each nurse in one loop.

is it possible?

thanks in advance

Do you have a another table for the nurses where each nurse has a unique record? It can get a bit complex without it.

No I don't have any other table. how could it help me and what design should it be?

Thanks

... at the end of the month i need a separate list of each nurse and the number of days that he or she visited my GM.

A summary report should do this, and it will be accurate as long as the nurse's names are entered consistently. No looping scripts necessary. Just find the date range of visits, then sort by nurse name and change to the report layout.

... and export them as excel file for each nurse

A summary report should do this

Do go on, please.

Thank you so much guys,

your suggestion opens a new door to solve many problems for me.

I made a report layout which show exactly what I want, the only problem is how can I set the report for date range?

kind regards

Thank you so much guys,

your suggestion opens a new door to solve many problems for me.

I made a report layout which show exactly what I want, the only problem is how can I set the report for date range?

kind regards

Do a find by the date range - then do the report