Jump to content
Server Maintenance This Week. ×

10 page Contract of Employment and merge fields.


ttmail

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

Recommended Posts

I have a contract of employment which runs to 10 pages. 

 

I am trying to create a layout report for all of these pages and am having difficulty in inserting the whole COE and page breaks so I can print all of these pages off and also merge some of the data like name, address, date employee started, etc.

 

Can you do a report for 10 pages in Filemaker and merge some fields?

 

I can show you the database and COE if that would help someone who can help me.

 

Thanks for your help in advance and I hope my explanation is OK.

Link to comment
Share on other sites

One way to handle merges is use a substitution.  You need the contract template which is brought in fresh when you create a contract record.  In the template you have  your <<FirstName>>   <<LastName>>  etc. 

 

When a contract is created, you either read the  read merge data directly from the contact recrod or prior to creating the contract, load global fields with this information.

 

Once the contract record is formed have a script that systematically does the substitution in the merge place holders.

 

Eg in pseudiscript:   If pattern count "<<" is greater than 0

 

Set field Contract (Substitute (Contract, "<<FirstName>>"; FirstNamefield ))

 

If you contract is made up of multiple fields, you will have to isolate where the individual merges take place.

 

HTH

 

Dave

Link to comment
Share on other sites

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