Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

adding multiple entries into same field


This topic is 7177 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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?

Posted

With menus, the Shift key while allows multiple selections. Not sure if ot works for lists.

Posted

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.

Posted

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, "par.gif", " " ) will replace the paragraph with a space.

Posted

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.

This topic is 7177 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.