March 31, 200520 yr I have a portal with a field filled in by pop up list. eg. can choose entry a, entry b, entry c etc. Is there a way to choose entry a then add next to it entry b, then add entry c so that the field ends up as "entry a entry b entry c". I tried to place that data on the layout and cut and paste but it won't allow. Any suggestions?
April 1, 200520 yr With menus, the Shift key while allows multiple selections. Not sure if ot works for lists.
April 1, 200520 yr Author thanks, on the mac the apple key allowed multiple entries. As of now it puts it as entry a entry b entry c each in its own row instead of entry a entry b entry c. It is a start and at least the data is in the field. Maybe next I can figure out how to remove the returns.
April 1, 200520 yr FMP is giving you a paragraph delimited list of entries. Some form of delimiter is required so you can separate the entries again later. It also allows the entry to be used as a multi-key for relationships, which is very useful. If you do strip out the paragraphs be aware that there may be no reliable way to separate the separate entries again. Substitute( textfield, "", " " ) will replace the paragraph with a space.
April 1, 200520 yr It should be noted also that the calculation can be added to the field's Auto-Enter by Calculation (unclick 'Do Not Replace Existing Values'). In this way, each time a User adds something to the multiline field, it will simply convert itself to the proper single-line format. It's one of the perks of vs. 7 - a field's ability to reformat itself on the fly.
Create an account or sign in to comment