Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Appending records

  
   Database Forums (Home) -> FileMaker RSS
Next:  Help on manual reinstall Sql Service  
Author Message
davidpreswick

External


Since: Nov 15, 2008
Posts: 2



(Msg. 1) Posted: Sat Nov 15, 2008 4:02 am
Post subject: Appending records
Archived from groups: comp>databases>filemaker (more info?)
I have a solution which has a quiz component. I would like all the
questions and answers to the quiz to be appended into one field as
this field will for part of a letter sent to the person who has sat
the quiz.
ie I need to append 2 fields (Q and A) per line and then append
multiple records below. I have tried scripting with a loop using set
field but it replaces the entire contents. Any ideas ?
Thanks heaps in advance. David

 >> Stay informed about: Appending records 
Back to top
Login to vote
Ursus

External


Since: May 26, 2008
Posts: 18



(Msg. 2) Posted: Sat Nov 15, 2008 10:25 am
Post subject: Re: Appending records [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
schreef in bericht

>I have a solution which has a quiz component. I would like all the
> questions and answers to the quiz to be appended into one field as
> this field will for part of a letter sent to the person who has sat
> the quiz.
> ie I need to append 2 fields (Q and A) per line and then append
> multiple records below. I have tried scripting with a loop using set
> field but it replaces the entire contents. Any ideas ?
> Thanks heaps in advance. David

It would have helped if you posted the script along with your question, but
my guess is you have forgotten to port the old value of the field

MyField

Set Field MyField < MyField & WhatEverComesNext >

Keep well, Ursus

 >> Stay informed about: Appending records 
Back to top
Login to vote
davidpreswick

External


Since: Nov 15, 2008
Posts: 2



(Msg. 3) Posted: Sun Nov 16, 2008 3:32 am
Post subject: Re: Appending records [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Nov 16, 1:57 am, "Ursus" wrote:
> schreef in berichtnews:6e7b1830-af6c-402f-b398-4bf481a16ffe@a29g2000pra.googlegroups.com...
>
> >I have a solution which has a quiz component. I would like all the
> > questions and answers to the quiz to be appended into one field as
> > this field will for part of a letter sent to the person who has sat
> > the quiz.
> > ie I need to append 2 fields (Q and A) per line and then append
> > multiple records below. I have tried scripting with a loop using set
> > field but it replaces the entire contents. Any ideas ?
> > Thanks heaps in advance. David
>
> It would have helped if you posted the script along with your question, but
> my guess is  you have forgotten to port the old value of the field
>
> MyField
>
> Set Field MyField < MyField & WhatEverComesNext >
>
> Keep well, Ursus

Thanks Ursus
You are absolutely right! I forgot to port the old value - problem
solved.
Thanks
David
 >> Stay informed about: Appending records 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Exporting records through the web - I would like to use FileMaker Server to publish several large data tables on the web. Two (non-technical) staff members need to be able to create tables, import data, and create layouts through FileMaker Pro. End users need to be able to access the..

Relate records - hello everyone, firstly,Sorry for my poor English. Secondly,I need help about make relate table. I have 2 tables from 2 files.A and B. A has record A_id. B has record B_id and B_SR. I try to made relation between A and B. B just show in portal if B_id or...

Showing just the records we want - Hello, dealing with some presentations, we came across to the following situation: we want to show the user just the records we want, using some specific conditions. As far as we know (me not fm expert and our filemaker guy), the user can make a search...

Import Records - I have a small collection of records that I imported from an Excel spreadsheet using FM8.5. Each record contains an Order Number which I then run another Import Records using and ODBC connection to pull more detailed information about the specific Order...

Records and Scripting - Hi, I have a script that duplicates every record in a Find and modifies the duplicate. At the end, another script runs that duplicates some records again based on a certain parameter. The problem is that when the second script runs, it will only duplicat...
   Database Forums (Home) -> FileMaker All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]