You are making copies of the very same field when you do this on your layout. Instead, you could consider two alternatives:
- Go into Manage | Database Fields, define two new fields (1 is your calculation) and then return to your layout and use the field tool to add them to your layout.
- Use a list view or portal to get your multiple rows of data and then you would add more records while in Browse mode to get additional rows of data.
OK, just to make sure I've got this right using option 1:
In my table...fields section...
a) I have a field, type=text, Indexed, By Value List (this is my 15 options);
b) I also have my second field, type=calculation (used case and it's working fine).
When I go to layout mode, I use field/control tool to enter a new field, one which will have my value list (Inspector Tool allows me to assign the value list), and the 2nd field, which contains my calculation.
I did this step for row one, and it works no problem. I did the step again for row two, repeating from ..."field/control tool to enter a new field" but it's not working. The same thing is happening as noted in original post. I select a value from my list in the second row and it changes my original selection made in my first row.
I'll look again tomorrow. There's got to be something I'm not interpreting correctly from your instruction. I'll also see if I can use option 2 after getting some sleep. Ha!!
Perhaps your 2 rows are both on the same record and you are using Form View? Try using List View so that each row is a separate record.
If you need 2 value lists on 1 record then you might make them separate fields such as List 1 and List 2. You can attach the same value list to both fields if that is your desire.
What you are doing is putting the same field on your layout over an over again instead of a new field or (and this most likely the right option) a new record--something that you do in browse mode.
OK, so hopefully there's a simple solution to this one. If I'm using the following code:
Case (Row_2 = "ABCD"; field1 & field2 & field3)
Is there a way to get each field to show up on different lines? They show up as expected, but I want them all separated by a line so that 1 is on top of 2 is on top of 3.
Also, is there a way to write into a calculation that returns text something like html code allows? I.E. making text appear bold, or in italics for ex.?
List ( field1 ; Field2 ; Field3 )
This is great...however, unless I click into the field where things are listed, a "?" appears.
This is how I have it written:
Case (Row_2 = "ABCD"; List ( field1; field2; field3 ))
What gets returned when Row 2 says ABCD is:
unless I put my cursor in the field where the question mark is...then it shows the desired result below.
Make sure that your calculation's result type is Text. You'll also need to size the field to be three rows of text in height before you can see all of the data returned.
OK, got it. Thanks! It's looking really great now. Is there any way to force a break between each item? Skip a line? I tried inserting "" for empty text as part of my list, but it doesn't work.
I'll keep tooling with it.
Actually, I see if I insert a space between my quotes it works :-)
Hmmm...my last post evaporated. I figured out how to force the break. Thanks!
Perhaps you didn't click the control for page 2.
You could also change the line spacing setting in the Inspector's appearance tab to increase the vertical spacing between lines of text...
Hi Phil - (and anyone else!),
Case (IsValid ( Field1 ); List (Field1; Field2; Field3))
This returns the values I want, but not in the format I would like. is there a way to format this so that all values in referenced fields show up in a row rather than one on top of each other? Also, I'm looking for a way to insert a line break. I've looked through the text formatting options and I don't se anything appropriate. Am I missing something obvious?
Thanks so much!