dbTalk Databases Forums  

Append a text line to a field BUT NOT replace contents

comp.databases.filemaker comp.databases.filemaker


Discuss Append a text line to a field BUT NOT replace contents in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JayBee
 
Posts: n/a

Default Append a text line to a field BUT NOT replace contents - 01-07-2010 , 06:36 AM






Hi

Yes it's me again. I have got a check box field formatted as a
button. If the check box is selected to on then as well as putting a
check in the box I want to add a text line to a field, as stated
above, not replacing any existing contents of that field but appending
the text to it.

I know the theory of the script that I need to use. My question is
which script-step function to use in order to append the text.
I think set field won't work becasue that usually replaces the whol
contents. Then there's copy and paste and there's set selection,
insert text.

Any help greatly appreciated.

Thanks
JayBee

Reply With Quote
  #2  
Old   
Lynn Allen
 
Posts: n/a

Default Re: Append a text line to a field BUT NOT replace contentsX-TraceApproved - 01-07-2010 , 11:49 AM






On 2010-01-07 04:36:40 -0800, JayBee <Jennifer_Beecroft (AT) hotmail (DOT) com> said:

Quote:
I know the theory of the script that I need to use. My question is
which script-step function to use in order to append the text.
I think set field won't work becasue that usually replaces the whol
contents. Then there's copy and paste and there's set selection,
insert text.
Set Field (TargetFieldName; TargetFieldName & "<p>" & "New text goes here")

That <p> is the paragraph character, which doesn't render in all news readers.

So you preserve the original contents by including it in the
calculation, then insert a return, and the new text.

--
Lynn Allen
--
www.semiotics.com
Member FBA
FM 10 Certified Developer

Reply With Quote
  #3  
Old   
Ursus
 
Posts: n/a

Default Re: Append a text line to a field BUT NOT replace contents - 01-07-2010 , 11:57 AM



Hi Jen

Set Myfield ( Myfield & " " & OtherFieldContainingText )


--
Keep well / Hou je goed

Ursus

"JayBee" <Jennifer_Beecroft (AT) hotmail (DOT) com> schreef in bericht
news:aee9eaff-a2fb-4ca2-b926-c8d86cc8caca (AT) h9g2000yqa (DOT) googlegroups.com...
Quote:
Hi

Yes it's me again. I have got a check box field formatted as a
button. If the check box is selected to on then as well as putting a
check in the box I want to add a text line to a field, as stated
above, not replacing any existing contents of that field but appending
the text to it.

I know the theory of the script that I need to use. My question is
which script-step function to use in order to append the text.
I think set field won't work becasue that usually replaces the whol
contents. Then there's copy and paste and there's set selection,
insert text.

Any help greatly appreciated.

Thanks
JayBee

Reply With Quote
  #4  
Old   
JayBee
 
Posts: n/a

Default Re: Append a text line to a field BUT NOT replace contents - 01-14-2010 , 03:00 PM



Thanks Everyone

It worked a treat by the way.

I will remember Set MyField (MyField & " " & NewField)

Eehxcelllent
:-D

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.