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

Multiple fields


Steve S

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

Recommended Posts

k.. I've searched the forums and found a few posts on just this topic, but i must be missing some fundamentl understanding of scripting.

here's what i want to do. I have fields A, B, C, and D on a layout.

I want to put a FIND ALL field on the layout where the user can enter what they want, click a button, and all the fields(a to d) are searched with the entry.

Now, I set up a CalcALL field that puts these all together into one searchable field. what i'm missing is how to tell the script to take the data in the FIND ALL field and use it to search the CalcALL field.

I hope this makes sense, and sorry if this is basic.

thanks

Steve

Link to comment
Share on other sites

First, The "FIND ALL" field MUST be a global fields or its contents won't be available for use when in Find mode.

Enter Find Mode[]

SetField[CalcAll, FIND ALL]

Perform Find[]

Without the CalcALL field:

Enter Find Mode[]

SetField[A, FIND ALL]

New Record/Request/Page

SetField[b, FIND ALL]

New Record/Request/Page

SetField[C, FIND ALL]

New Record/Request/Page

SetField[D, FIND ALL]

Perform Find[]

New request are "OR'ed", without the New Request steps, a record would have to match all four fields at the same time to be found.

-bd

Link to comment
Share on other sites

Hi,

depending on how large is the db, and if fields A to B are B)

- indexed fields,

- of same format (but this is also true for the Perfor find script),

you could also use some kind of relationships here.

1.Create a stored calculation

Multi-key = "field A" & "

Link to comment
Share on other sites

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