AnsweredAssumed Answered

Adding text in a field conditionally

Question asked by matshawk on Nov 26, 2012
Latest reply on Nov 30, 2012 by LyndsayHowarth

Hi all

 

This is my first post and i hope i will get some answer to my question.

 

Background:

I have a design that i use for maintenance task lists.

One task list can occur several times over the year. The have numbers like the pic below.

 

Task list

Task list counter

Maintenance number

 

The combination of these fields can occur several times over a period.

 

Now, if i write a comment in the Comments field, i would like that to show in the result field. That means that every time i write something new in the Comments field i would like to add that text to the previous text in the Result field if the Task list, Task list number and Maintanance Number are the same. The field Comments should be able to be emptyed and still the text should appear in Result.

 

Also if i insert a picture in the Image container in one record, the Image container should hold the same picture in all records with the same combinations of said fields.

FM.jpg

I hope i have made my self clear...

 

Best regards

Mats "FileMaker Rookie", Sweden

Outcomes