You’re offline. This is a read only version of the page.
634
I'm trying to create a tool where users can utilize a variety of inputs that are independent of each other. For example.
Product combo box (12 items)
Campaign Name combo box (102 items)
Source combo box (20 items)
Right now I am simply dropping combo boxes on a canvas and creating a datasource for each one but I am not sure if this is the right way to do this or should all of this data be in a single datasource in their own columns? My experience with databases says they need to remain separate data sources since a row in a table is a record where all items are dependent.
Now, the output will go to a single datasource but am I going about building the input the right way?
Yeah, so if there is not much more complexity than that, your approach is fine.
There really aren't any dependencies that I can think of. At least not on the input side other than un-hiding certain fields if a value, or a specific value, is entered in another field. For example, the Source dropdown. If the source is '3rd Party" then a text field is displayed to enter the name of the third party. That is about as complicated as it gets.
As for size of lists I think Brand is the biggest list although Products could eventually be as big. We're talking maybe 300-400 records
In general this is not a bad approach. It really depends on the amount of data that you will deal with in the list and what additional relationships you need from it.
For example, if the Campaign Name will potentially be filtered by what is in the Product, then having a relationship from Product to Campaign will be needed. This can easily be done in a single list, but if not, then your Campaign list will need to have another column for the Product so you can filter on this later. That is relatively simple.
If you do it all in a single list, then you can utilize functions like GroupBy to get the relationship.
So, to answer your question...yes it is good, but it depends on where you are going with it all ultimately.
I hope this is helpful for you.
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
