Jump to content

Merging?


nightdesigns
 Share

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

Recommended Posts

Is there a way to automatically export into a form and dump to clipboard?

Situation, i have a bunch of fields used for e-bay, and i'd like to have it automatically drop all the fields into a html template that i can just paste (it doesn't have to go to an external program, just to clipboard)

Hopefully you can make sense of that.

Thanks

File Maker Pro Version 5

Link to comment
Share on other sites

I would start by creating the html template with dummy data for the fields using something like Claris Homepage. So, you would get something like this:

<html blah blah...> field1 <html blah blah...> field2 <html blah blah...> field3 <html blah blah...> etc.

Create some global text fields in your database. Then copy from your html template from the beginning to where field1 begins, and paste it into the first global. Then copy everything from the end of field1 to the beginning of field2 and paste it into the second global, and so on until you have all of the html code copied over. Your globals now contain the html formatting stuff. Then to format your data, make a calculated field called Html with the following calculation:

Html = global1 & field1 & global2 & field2 &global3 & field3 & global4 ... etc.

At this point you can create a script that simply copies from the Html field.

Link to comment
Share on other sites

I got it to work, took a bit of toying around and a few choice words at the computer, but i got it. I created a calculation field. Basically has the formatting text, and then the fields in it. Down side, calc fields (along with any other type of calc field can only be 253 characters), so i ended up making 11 fields (some w/ fields inserted, some with not). I created a 12th field to add all those together. I made sure that it didn't store the result to the file, ebcause it would have gotten huge. Server is fast enough to do the calcs as needed. Then set up a button to click when the user wants it dumped to clipboard.

Thanks

Link to comment
Share on other sites

I forgot about the 253 character limit. Curiously, this limit does not apply to all calculations. If you use the Set Field instruction in a script, you can use text functions with much larger amounts of text. I use a script that imports and parses all of my email messages which are typically in the 3k to 5k size range. The size restrictions don't seem to be very well documented in the manual.

Link to comment
Share on other sites

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