Jump to content

Nice and easy question about if tests


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

Recommended Posts

We are sending data from filemaker to sage using some scripts. We have found that the process breaks if there is no company name defined when posting. I would therefore like to alter the script so that on posting it checks to make sure there is a company name and if not instead sends the Firstname and Surname as the company name.

Our current script:

SET FIELD [sage::accountname; MD::CompanyName]

What I would like:

SET FIELD [sage::accountname;

Then the second part defined by an if test(which I am not sure if it is right - hence the question):

If ( MD::CompanyName; MD::CompanyName; MD::FirstName MD::Surname )

So I am trying to say if companyname is defined (or true) then show companyname as accountname else use firstname and surname. Have I got it right though?

Link to comment
Share on other sites

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