Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

I wish I knew

I am running a script that populates a field with a picture according to another field's value from a value list.

My problem is that it will only do one record at a time. I need to run the script from each record then all is fine.

My teachers will be using only records associated with their class (another field)

Is there a way to get the script to populate all records without compromising the fact that they are working with a specific group?:?

Any thoughts would be greatly appreciated

Many thanx

Poida confused.gif

Posted

Hi,

Do you mean for each value from your value list, or for all records from this database ?

If the value list is related, work with combination of globals and loop scripts within both the related files and the Main file.

If it is for all records of the Main file, a loop script in the Main file with a next record step and a global to store the image...

Posted

1. why a script? a calculation will do as well

Case(field1;"auto",pixauto,"bike",pictures::bike, "train",getrepetition(g_pictures,2,"").

Make sure the calc results in a container.

2. scripted

go to record, first

loop

if field1="auto"

setfield, picture,pixauto

end if

if ....

...endif

go to record,next, stop at last record

end loop

3: or do a lookup based on a relation

This topic is 7864 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
×
×
  • Create New...

Important Information

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