Lantica User Forum - Mail merge and number fields

(UTC)

Lantica User Forum › Archived Topics › Archived Topics › Mail merge and number fields

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Hot Topic (More than 10 Replies)

Mail merge and number fields (Read 1506 times)

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Mail merge and number fields Mar 11^th, 2004 at 2:01pm	Print Post
	I have a mix of number, money, date and text fields that I wish to mailmerge. They look fine, on screen, but, when merged to Word, the number and money fields all print out about four zeros after my entry. Example $24.95 in the data, comes out $24.950000 in the merge. This is a very large database, that was originally QA4. Also, I had in QA4 a date field that I only updated by Mass update. For some reason this field will not merge. Maybe because it is now empty?


	WWW IP Logged

Bharat_Naik Senior Member Members Offline Ever ready to learn and share Posts: 1202 Location: Chicago, Illinois Joined: Dec 16^th, 2003	Re: Mail merge and number fields Reply #1 - Mar 11^th, 2004 at 2:36pm	Print Post
	You will have to use Mergefield modifier in the MS Word to change the formating. You will find this information in the programming Manual Page 242 and 243.


	IP Logged

Bharat_Naik Senior Member Members Offline Ever ready to learn and share Posts: 1202 Location: Chicago, Illinois Joined: Dec 16^th, 2003	Re: Mail merge and number fields Reply #2 - Mar 11^th, 2004 at 2:47pm	Print Post
	Quote: Also, I had in QA4 a date field that I only updated by Mass update. For some reason this field will not merge. Maybe because it is now empty? If the field is empty, it has no data to merge. May be you need to do Mass Updateing first or change the programming so, date gets updated without going through mass updateing. Sesame has a lot more flexibility and events as compared to Q&A. By the way, you may also need to change the formating for date in MS Word as it will take date in YYYY/MM/DD format, that is how it is stored internally in Sesame.


	IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Mail merge and number fields Reply #3 - Mar 15^th, 2004 at 8:30pm	Print Post
	Thanks, I'll have a go at that


	WWW IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Mail merge and number fields Reply #4 - Mar 16^th, 2004 at 3:45pm	Print Post
	Ok, now I can't do a mass update. Or rather, I can, but the results vanish. I am trying to mass update a date field. It was in QA4 a read only field, that I changed only once a year. So far, I have removed the read only parameter, andn entered the following mass update statement, that tested OK Decoration Day is = "July 11, 2004" This runs fine, it asks to update all 1236 records, I tell it to update all, and I can see it being entered as 07/11/2004, but when the update is finnished, the fields are all empty.


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Mail merge and number fields Reply #5 - Mar 16^th, 2004 at 4:14pm	Print Post
	Is there other programming on your form that might be clearing this field?

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Mail merge and number fields Reply #6 - Mar 16^th, 2004 at 4:22pm	Print Post
	This field is simply copied to the mail merge as an information field, the date is totally irrelevent to anything else in the form. So, no there are no programming statements of any kind connected to this field.


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Mail merge and number fields Reply #7 - Mar 16^th, 2004 at 5:04pm	Print Post
	I just tried your Mass Update on a sample application, and it works fine. If you type "July 11, 2004" (without the quotes) into the element manually and Save the record by pressing F10, what happens? Does it retain the value?

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Mail merge and number fields Reply #8 - Mar 16^th, 2004 at 5:20pm	Print Post
	That also dissappears, as soon as F10 is pressed.


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Mail merge and number fields Reply #9 - Mar 16^th, 2004 at 5:24pm	Print Post
	Quote: That also dissappears, as soon as F10 is pressed. OK. If that doesn't work, neither will the Mass Update. 1. Can you type other dates into this element and have them stick? 2. Is this element actually bound to an underlying field? If so, what is the type of that field? 3. What is the output format for the element?

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Mail merge and number fields Reply #10 - Mar 16^th, 2004 at 5:42pm	Print Post
	Quote: OK. If that doesn't work, neither will the Mass Update. 1. Can you type other dates into this element and have them stick? 2. Is this element actually bound to an underlying field? If so, what is the type of that field? 3. What is the output format for the element? I'm very new at this program, so I may be wrong, but this field should not be Bound to anything, as far as I understand "bound". Perhaps I should jst erase the field, and create a new field, of the same name if I figure out how.


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Mail merge and number fields Reply #11 - Mar 16^th, 2004 at 6:08pm	Print Post
	Unbound elements cannot retain values. They can temporarily a display a value, such as the results of a calculation, but they don't actually store anything because they are not bound to a field. Fields store data. If your date element is unbound, it will not retain values between records, which is why you can't save or mass update it.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Mail merge and number fields Reply #12 - Mar 16^th, 2004 at 6:35pm	Print Post
	That would appear to be the problem, as the entry "bound to" is blank. Where do I go from here? Display format is 15/03/2003[] There are no other entries except for Bound to Type "Date", Read only "False", and Visible"true"


	WWW IP Logged

John_Y_Cannuck Junior Member Offline decidedly un-geek! Posts: 97 Location: Lindsay Ontario Canada Joined: Mar 8^th, 2004	Re: Mail merge and number fields Reply #13 - Mar 16^th, 2004 at 6:43pm	Print Post
	Changing the bound field to have it bound to itself seems to have worked, the mass update functioned nicely, thanks


	WWW IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge