|
»
»
»
Many fields to one value list
|
View:
New views
12 Messages
—
Rating Filter:
Alert me
|
 |
Many fields to one value list
by LOUIS ARDOLINO-2
::
Rate this Message:
Hello all
I have a question regarding a solution that I want to run: I have about 10-15 fields that a client setup to "look" like a value list but is actually just single fields with value lists of the actual data as a check box. I want to put all these 15 fields into one value list. Is there an easy way to do this? -- Louis Ardolino Forrex Solutions/The Office Nerd 917-650-8467 201-221-3090 Www.officenerd.com _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Many fields to one value list
by Jonathan Fletcher
::
Rate this Message:
On Aug 20, 2008, at 1:56 PM, Lou Ardolino wrote:
> I have about 10-15 fields that a client setup to "look" like a value > list but is actually just single fields with value lists of the > actual data as a check box. > > I want to put all these 15 fields into one value list. > Is there an easy way to do this? Make a calc that concatenates the fields with carriage returns, and then base your value list on that calc field. j. -- Jonathan Fletcher jfletch@... Project Foreman NewMedia Construction Co. _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Many fields to one value list
by Søren Dyhr
::
Rate this Message:
Den 20/08/2008 kl. 19.56 skrev Lou Ardolino: > I want to put all these 15 fields into one value list. > Is there an easy way to do this? Put these values a few relational step away, the question suggest a less than normalized solution, since each field are likely to share attributes in the long run, since nothing here suggest a exhaustion via permutation. Still though is it a many 2 many relation I envision here? --sd _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Many fields to one value list
by LOUIS ARDOLINO-2
::
Rate this Message:
They are working as tags to classify the type of contact here. The easiest solution is to group them as value lists. So I have the following fields: a&r, publicist, marketing, record label, club/venue, lawyer, manager, film company, producer, agent, wire service, radio, retail, artist, tour mgr, music video, video games
I want to put all these field values into one value list called: industry tags, with the values being the above. How can I do such? On 8/21/08 10:58 AM, "Søren Dyhr" <jamsessionware@...> wrote: Den 20/08/2008 kl. 19.56 skrev Lou Ardolino: > I want to put all these 15 fields into one value list. > Is there an easy way to do this? Put these values a few relational step away, the question suggest a less than normalized solution, since each field are likely to share attributes in the long run, since nothing here suggest a exhaustion via permutation. Still though is it a many 2 many relation I envision here? --sd _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au -- Louis Ardolino Forrex Solutions/The Office Nerd 917-650-8467 201-221-3090 Www.officenerd.com _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Many fields to one value list
by Søren Dyhr
::
Rate this Message:
Den 22/08/2008 kl. 12.03 skrev Lou Ardolino: > I want to put all these field values into one value list called: > industry tags, with the values being the above. Ah! thats the problem you are confusing attributes and fields, there should only be one single field, with a valuelist attached. The appearance of this field should then be either a radio-button or a checkbox'ed... The distinction you have to make between the two is; could a person in you system wear several hats or is one occupation a sufficient description? --sd _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Many fields to one value list
by LOUIS ARDOLINO-2
::
Rate this Message:
Yes, this person will wear several hats. This is why I want to make all those fields into a value list.
On 8/22/08 8:10 AM, "Søren Dyhr" <jamsessionware@...> wrote: Den 22/08/2008 kl. 12.03 skrev Lou Ardolino: > I want to put all these field values into one value list called: > industry tags, with the values being the above. Ah! thats the problem you are confusing attributes and fields, there should only be one single field, with a valuelist attached. The appearance of this field should then be either a radio-button or a checkbox'ed... The distinction you have to make between the two is; could a person in you system wear several hats or is one occupation a sufficient description? --sd _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au -- Louis Ardolino Forrex Solutions/The Office Nerd 917-650-8467 201-221-3090 Www.officenerd.com _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Many fields to one value list
by Bart Bartholomay
::
Rate this Message:
Well, why not choose the type of "hat" this person is using at any
given time and limiting your values to those that specifically belong to that type instead of commingling all of them into one? You're really asking for trouble with the right data into the right field by doing it your way. Bart Bart Bartholomay HAB Marketing 3725 8th Lane Vero Beach, FL 32960 772.299.6352 http://HABMarketing.com On Aug 22, 2008, at 10:30 PM, Lou Ardolino wrote: > Yes, this person will wear several hats. This is why I want to make > all those fields into a value list. > > > On 8/22/08 8:10 AM, "Søren Dyhr" <jamsessionware@...> wrote: > > > > Den 22/08/2008 kl. 12.03 skrev Lou Ardolino: > >> I want to put all these field values into one value list called: >> industry tags, with the values being the above. > > Ah! thats the problem you are confusing attributes and fields, there > should only be one single field, with a valuelist attached. The > appearance of this field should then be either a radio-button or a > checkbox'ed... > > The distinction you have to make between the two is; could a person in > you system wear several hats or is one occupation a sufficient > description? > > --sd > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au > > > -- > Louis Ardolino > Forrex Solutions/The Office Nerd > 917-650-8467 > 201-221-3090 > Www.officenerd.com > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Many fields to one value list
by LOUIS ARDOLINO-2
::
Rate this Message:
Agreed.
Although this is just the way that they have been operating. I could use some help with the calculated field though as im not doing something correct So if the field is going to be industryType then: industryType = aAndR(return)publicist(return)marketing(return)>>>> Is that correct? On 8/22/08 10:49 PM, "Bart Bartholomay" <bart@...> wrote: -- Louis Ardolino Forrex Solutions/The Office Nerd 917-650-8467 201-221-3090 Www.officenerd.com _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Many fields to one value list
by Bart Bartholomay
::
Rate this Message:
You're going to have to set up the scenario a little differently.
First, create a field called IndustryType. This is a calculated text field that will contain the concatenated status of each of the fields that are separate right now. Here's how to set up that calculation. Note that I'm using YOUR field names that exist now (at least what I think they are): AandR, publicist, marketing, record label, club/venue, lawyer, manager, film company, producer, agent, wire service, radio, retail, artist, tour mgr, music video, video games IndustryType (text, calc) = Case(not IsEmpty(AandR); "AandR") & // note that there's no "¶" & in this line Case(not IsEmpty(Publicist); "¶" & "Publicist") & Case(not IsEmpty(Marketing); "¶" & "Marketing") & Case(not IsEmpty(Record Label); "¶" & "Record Label") & ... ... Case(not IsEmpty(Video Games); "¶" & "Video Games") There are 18 of these lines in the calculation (one for each of the 18 values in the list). Now create a value list with these same field names in it. On your layout create IndustryType as a checkbox object and assign it's value list to the one you just created. Now, VERY IMPORTANT, make sure your IndustryType field is a STORED calculation. If it is, then you may redefine it to a text field (not calculated). You will now have the appropriate values for each record entered into the IndustryType field, which is displayed as a checkbox on your layout (approx as it was before). hth, Bart Bart Bartholomay HAB Marketing 3725 8th Lane Vero Beach, FL 32960 772.299.6352 http://HABMarketing.com On Aug 22, 2008, at 11:02 PM, Lou Ardolino wrote: > Agreed. > > Although this is just the way that they have been operating. I > could use some help with the calculated field though as im not doing > something correct > > So if the field is going to be industryType then: > > > industryType = aAndR(return)publicist(return)marketing(return)>>>> > > Is that correct? > On 8/22/08 10:49 PM, "Bart Bartholomay" <bart@...> wrote: > > > > -- > Louis Ardolino > Forrex Solutions/The Office Nerd > 917-650-8467 > 201-221-3090 > Www.officenerd.com > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Many fields to one value list
by Tom Elliott
::
Rate this Message:
Lou (& Bart)
On 23 Aug 2008, at 5:34, Bart Bartholomay wrote (in part): > <snip> > > IndustryType (text, calc) = > > Case(not IsEmpty(AandR); "AandR") & // note > that there's no "¶" & in this line > Case(not IsEmpty(Publicist); "¶" & "Publicist") & > Case(not IsEmpty(Marketing); "¶" & "Marketing") & > Case(not IsEmpty(Record Label); "¶" & "Record Label") & > ... > ... > Case(not IsEmpty(Video Games); "¶" & "Video Games") using this calc you will get a stray leading carriage return in cases where the field AandR is not set, so instead you could use: IndustryType = List ( If ( not IsEmpty ( AandR ) ; "AandR" ) ; If ( not IsEmpty ( Publicist ) ; "Publicist" ) ; … If ( not IsEmpty ( Video Games ) ; "Video Games" ) ) cheers Tom _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Many fields to one value list
by LOUIS ARDOLINO-2
::
Rate this Message:
Thank you!!!
On 8/23/08 12:34 AM, "Bart Bartholomay" <bart@...> wrote: You're going to have to set up the scenario a little differently. First, create a field called IndustryType. This is a calculated text field that will contain the concatenated status of each of the fields that are separate right now. Here's how to set up that calculation. Note that I'm using YOUR field names that exist now (at least what I think they are): AandR, publicist, marketing, record label, club/venue, lawyer, manager, film company, producer, agent, wire service, radio, retail, artist, tour mgr, music video, video games IndustryType (text, calc) = Case(not IsEmpty(AandR); "AandR") & // note that there's no "¶" & in this line Case(not IsEmpty(Publicist); "¶" & "Publicist") & Case(not IsEmpty(Marketing); "¶" & "Marketing") & Case(not IsEmpty(Record Label); "¶" & "Record Label") & ... ... Case(not IsEmpty(Video Games); "¶" & "Video Games") There are 18 of these lines in the calculation (one for each of the 18 values in the list). Now create a value list with these same field names in it. On your layout create IndustryType as a checkbox object and assign it's value list to the one you just created. Now, VERY IMPORTANT, make sure your IndustryType field is a STORED calculation. If it is, then you may redefine it to a text field (not calculated). You will now have the appropriate values for each record entered into the IndustryType field, which is displayed as a checkbox on your layout (approx as it was before). hth, Bart Bart Bartholomay HAB Marketing 3725 8th Lane Vero Beach, FL 32960 772.299.6352 http://HABMarketing.com On Aug 22, 2008, at 11:02 PM, Lou Ardolino wrote: > Agreed. > > Although this is just the way that they have been operating. I > could use some help with the calculated field though as im not doing > something correct > > So if the field is going to be industryType then: > > > industryType = aAndR(return)publicist(return)marketing(return)>>>> > > Is that correct? > On 8/22/08 10:49 PM, "Bart Bartholomay" <bart@...> wrote: > > > > -- > Louis Ardolino > Forrex Solutions/The Office Nerd > 917-650-8467 > 201-221-3090 > Www.officenerd.com > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au -- Louis Ardolino Forrex Solutions/The Office Nerd 917-650-8467 201-221-3090 Www.officenerd.com _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Many fields to one value list
by Bart Bartholomay
::
Rate this Message:
Yes, that's true, but in checkboxes it really doesn't matter. I
suppose you could put the carriage return after the FIeld Name. But your take is even better. Bart Bart Bartholomay HAB Marketing 3725 8th Lane Vero Beach, FL 32960 772.299.6352 http://HABMarketing.com On Aug 23, 2008, at 3:46 AM, Tom Elliott wrote: > Lou (& Bart) > > > On 23 Aug 2008, at 5:34, Bart Bartholomay wrote (in part): > >> <snip> >> >> IndustryType (text, calc) = >> >> Case(not IsEmpty(AandR); "AandR") & // note >> that there's no "¶" & in this line >> Case(not IsEmpty(Publicist); "¶" & "Publicist") & >> Case(not IsEmpty(Marketing); "¶" & "Marketing") & >> Case(not IsEmpty(Record Label); "¶" & "Record Label") & >> ... >> ... >> Case(not IsEmpty(Video Games); "¶" & "Video Games") > > using this calc you will get a stray leading carriage return in > cases where the field AandR is not set, so instead you could use: > > IndustryType = > List ( > If ( not IsEmpty ( AandR ) ; "AandR" ) ; > If ( not IsEmpty ( Publicist ) ; "Publicist" ) ; > … > If ( not IsEmpty ( Video Games ) ; "Video Games" ) > ) > > cheers > > Tom > > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
| Free Forum Powered by Nabble | Forum Help |
