swf Posted March 31, 2005 Posted March 31, 2005 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?
Vaughan Posted April 1, 2005 Posted April 1, 2005 With menus, the Shift key while allows multiple selections. Not sure if ot works for lists.
swf Posted April 1, 2005 Author Posted April 1, 2005 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.
Vaughan Posted April 1, 2005 Posted April 1, 2005 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.
LaRetta Posted April 1, 2005 Posted April 1, 2005 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.
Ugo DI LUCA Posted April 1, 2005 Posted April 1, 2005 Take a look at this file that demostrates LaRetta idea... Affiliation.zip
Recommended Posts
This topic is 7522 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now