Jump to content

need a script to let me set a value list in a loop


NaderNouri
 Share

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

Recommended Posts

...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 "=".

Link to comment
Share on other sites

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

Link to comment
Share on other sites

... 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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 4302 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.