Hi!
I'm trying to achieve a CVL base on the excellent "Adventure 1 in CVLs" by
Hi!
I'm trying to achieve a CVL base on the excellent "Adventure 1 in CVLs" by
G...
So I could create TOs of Poduct Table and sets them like you did in Adventure 1 CVLs ?!
But How do I link them, those are just text field, no Numbers?
item_prod::no_brand to Product::Brand
and what?
Product::Group to which TO and field ?
Product::Category to which TO and field ?
Product::Type to which TO and field ?
tx
Brand to brand
group to group
category to category
type to type
in each relationship, you have to have matching values in both tables.
Sounds obvious, it starts to work a bit; my secund level got filled with values, but ALL values, not those only related to Brand. Just check Value List config in your demo, the secund one ; got only value ralated, but not woking
Le 03-févr.-2018 à 19:59, philmodjunk <noreply@filemaker.com> a écrit :
Re: CVL with values based on only one table, problems
réponse de philmodjunk <https://community.filemaker.com/people/philmodjunk?et=watches.email.thread> dans Discussions - Afficher la discussion complète <https://community.filemaker.com/message/733822?commentID=733822&et=watches.email.thread#comment-733822>
Brand to brand
group to group
category to category
type to type
in each relationship, you have to have matching values in both tables.
Répondre à ce message en répondant à cet e-mail, ou voir le message sur FileMaker Community <https://community.filemaker.com/message/733822?commentID=733822&et=watches.email.thread#comment-733822>
Commencer une nouvelle conversation dans Discussions par e-mail <mailto:discussions-community-discussions@mail.filemaker.jiveon.com> ou sur FileMaker Community <https://community.filemaker.com/choose-container.jspa?contentType=1&containerType=14&container=2310&et=watches.email.thread>
Abonné(e) à Re: CVL with values based on only one table, problems <https://community.filemaker.com/message/733822?commentID=733822&et=watches.email.thread#comment-733822> dans ces flux : Notifications
Gérer vos préférences email <https://community.filemaker.com//user-preferences!input.jspa>
FileMaker Developer Conference 2018 • Dallas, Texas • August 6-9 • www.filemaker.com/learning/devcon <http://www.filemaker.com/learning/devcon>
If I tell you that I'm on a layout Billings and my CVL are placed in a Portal of Item_Product, does it give you more info?
Le 03-févr.-2018 à 19:59, philmodjunk <noreply@filemaker.com> a écrit :
Re: CVL with values based on only one table, problems
réponse de philmodjunk <https://community.filemaker.com/people/philmodjunk?et=watches.email.thread> dans Discussions - Afficher la discussion complète <https://community.filemaker.com/message/733822?commentID=733822&et=watches.email.thread#comment-733822>
Brand to brand
group to group
category to category
type to type
in each relationship, you have to have matching values in both tables.
Répondre à ce message en répondant à cet e-mail, ou voir le message sur FileMaker Community <https://community.filemaker.com/message/733822?commentID=733822&et=watches.email.thread#comment-733822>
Commencer une nouvelle conversation dans Discussions par e-mail <mailto:discussions-community-discussions@mail.filemaker.jiveon.com> ou sur FileMaker Community <https://community.filemaker.com/choose-container.jspa?contentType=1&containerType=14&container=2310&et=watches.email.thread>
Abonné(e) à Re: CVL with values based on only one table, problems <https://community.filemaker.com/message/733822?commentID=733822&et=watches.email.thread#comment-733822> dans ces flux : Notifications
Gérer vos préférences email <https://community.filemaker.com//user-preferences!input.jspa>
FileMaker Developer Conference 2018 • Dallas, Texas • August 6-9 • www.filemaker.com/learning/devcon <http://www.filemaker.com/learning/devcon>
A screen shot of your relationships would be helpful to use in conjunction with what you have just shared.
Tx Phil, it starts to work!!!
I figure it out base on your Relations in the Graph
I'm in a hurry, but some Brand doesn't have the same numbers of Category, so I'm stuck a bit.
Had to fill at least two Type/Category
Would want a Based number of Cat depending on Brand...
If it's possible and doesn't take hours and not to complicated, I'll try it...
Hierarchical II is kind of greate but to heavy for my customer, and a bit of work for me in that moment
(The Super Bowl is on it's way...!!! - Go Pats Go )
Her's a SS - but it's in French. But you'll figure it out.
tx a lot.
Please list the categories from first to last in the order that you want your Hierarchical Value Lists to work. In other words from most general to most specific.
The methods used in that example are built on an assumption that may or may not be true for your data: That groups and sub groups don't "cross boundaries".
In the example, you pick a region (Northern or Southern California). Then a county, then a city. No city is in both regions nor is any one city in more than one county.
If, for example, your Hierarchy is:
Brand
Group
Category
Type
If Products in a given group have more than one Brand, this hierarchical method doesn't have data structured the way it needs to be to work.
1) Brand (Marques)
2) Group
3) Type
eventually I have another sub-type
and then finally... the product itself
tx
I'm not sure that I understand your description of the problem. Can you provide an example or two of what you mean by:
but some Brand doesn't have the same numbers of Category, so I'm stuck a bit.
Had to fill at least two Type/Category
Would want a Based number of Cat depending on Brand...
among other questions, does "number" refer to an ID or a quantity?
Tx Phil.
Here's the point: some Company (Brand) have one or more "Type" of products; say food, or electronics or cosmetics.
within those Types, we can "Categorise" them in such, like : Cake, Cookies or Computer, smart phone or Eye liner, gloss lips, etc.
But all the "Brand" don't have the same amount of Type and Categorie. Some just sells food stuf - "Type" and have only one "Categoriy", while other may have "Type", "Category", "Sub-Categoriy" and why not "Sub-Sub-Category".
And for sure, at the end, we have to drill down to "Product::ID" to get the price, name, code, etc.
Brand, Type, Category, Product::ID
Brand, Type, Category, Sub-Category, Sub-Category, Product::ID
Brand, Type, Category, Product::ID
Brand, Type, Category, Sub-Category, Product::ID
Brand, Type, Category, Sub-Category,Sub-Category,Sub-Category, Product::ID
All without "Empty" Pop-Menu,like say a dynamic sets of Pop-Menu - but I think it's to heavy...
But is there a solution, that could perhaps, do a clean Interface for customer to pick a Product.
tx a lot.
Varying numbers of groups shouldn't be a problem for a pop up menu or drop down list. The list will simply be longer or shorter depending on the choice made in the previous field in the "chain" of CVLs.
For cases where the next list of values will be a single item or empty:
A script could check and if there is only one possible value for the next value list, it could set it to that value to make the choice automatically.
If the next list will be empty, there's no sub category or no sub sub category for that selected set of values, Hide Object When could hide the field or there are ways that it might be set to display "N/A" or some such place holder.
That's what I tought. Great ! I'll try it and get to you for other feed!
Hi! Phil, sorry to mention that it finally worked !!
Tx a lot!
But few other question:
• How can I retreive the number of item in the next value list
• How to select the only one, if their is only one left in the next value list
• and if a product as only 2 out of 4 categories (sub, sub-sub, etc.) How can I be loading values in the product value list
if one of it's "Parent" value list is empty?
here's the schema
BRAND TYPE CAT SUB-CAT PRODUCT_ID
bla bla bla bla ID_Name
bla bla NONE NONE ? (should be able to select those from the last filled CVL - TYPE)
Since you are using a relationship where there is one record for each value in the value list, Count ( relatedTable::nonEmptyField ) will return the number of values in the next value list. A script could simply use set field to set the value of the field from the related record when that relationship matches to just one record.
The last issue would require a more sophisticated hierarchical value list, such as can be found in the same Adventures file where I have an example where you can select from the right most value list without first selecting from the first value lists.
Tx Phil!
Just tryed, but maybe I'm taking the wrong fields; I'm not getting good counts...
What I did was i bit tricky, but it works. Got it from try and catch maners.
Had to related to a calc field to get it working
Had to add the previous field in a cascading style to get what I wnted.
here's a shot of my graph
Now "Count ( relatedTable::nonEmptyField )" is what field ?
from Items_Produits - like (Items_Produits::_NOM_Categorie) OR from the child side : Produits____FAC__CVL__Categorie::z__calc__Marque_Revente.
Tx.
What prevents you from setting those up?
Each "box" in a relationship graph is called a "table occurrence". You can have multiple table occurrences that all refer to the same data source table.
So you can select that table occurrence and click the duplicate button (two plus signs) and create a second occurrence of the same table. This does not create a new table, just a new reference to the same table.
A reference in the resources section of that file refers to this tutorial, which may be useful if I have guessed correctly as to what problem you have encountered:
Tutorial: What are Table Occurrences?