Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Script find on two fields on two conditions


Bobg
 Share

Recommended Posts

I'm trying to get a script to find on two fields. I have the following script

working on the first condition but I need to add a second condition.

 

Enter Find Mode []

Insert Calculated Result [select; Line Items::Date_Sold; " > " & $$SearchOnDate]

Perform Find []

 

Now I also want the script to find on a second condition which is,

if the field Date_Sold is blank then include that also in the found set.

 

Thanks for your help

 

Bob Green

Link to comment
Share on other sites

Bob, have you tried finding in reverse ie. omitting blank values (using "*"), then inversely choosing your dates (omitting your chosen dates), then showing omitted only?

Link to comment
Share on other sites

Martin,

 

I'm trying to use the Insert Calculated Result command to do both finds in the one command. Is that possible?

 

P.S. Martin do you live in Christchurch and did I talk to you about 3 years ago?

 

Thanks

Bob

Link to comment
Share on other sites

Hi Bob, sorry no and no, but I won't take it personally!

Not sure if it is. I'm not a fan of Insert Calculated Result (mainly because I've never had to use it!).

I would do something like...

 

Show All Records

Enter Find Mode [ ]

Set Field [ Line Items:Date_Sold; "*" ]

New Record/Request

Omit Record

Set Field [ Line Items:Date_Sold; ">" & $$SearchOnDate ]

Perform Find [ ]

Show Omitted Only

 

Let me know if that does the job.

 

Martin

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use