YOu can do that via relationship or a script check
If ( Paid2Date > Today ) and emailshow = "yes" )
Go to Layout, etc,etc
Or Create a relationship TO with paid2date > today and Id = Id
then use that table oCcurence to search for your data.
I think that would be a good start at least.
Could you elaborate on your suggestions? Not sure i follow. Thanks
1 of 1 people found this helpful
Enter Find Mode [ ]
Set Variable [ $searchString; Value:" > " & Get( CurrentDate) ]
Set Field [ two_level::Paid2Date; $searchString ]
Set Field [ two_level::EmailsStatus; "yes" ]
Perform Find [ ]
I have tried and works for me no changes to RG ( relational graph)
try it of course using your tableNames
Message was edited by: ian.moree
You need to make code cleaner rather than having so much ">" ,etc in your scripts, try to
put them in variables like
$searchString.two or searchOne, searchTwo
helps with readability ..
I have a clients table and an email table.
The purpose of the script is to export all email addresses marked "yes" where the client's swpd2 date is greater than today.
Your script searches a table named TechSupport. If you want to find and export email addresses, you should search in the email table:
Go to Layout [ Emails ]
Enter Find Mode 
Set Field [ Email::Status ; "Yes" ]
Set Field [ Clients::swpd2; ">" & Get ( CurrentDate ) ]
The problem is that if i have a client record with 2 email addresses, one marked as yes, one marked as no, running the script will still allow an email address that is marked as no to be exported as long as there is another email address marked as yes linked to the same record.
That literally just clicked in my head as i was typing my last response and was in the middle of changing the script to the email layout when i read your post. That took care of it. Thanks to the both of you for your assistance.