You need to sign in to do that
Don't have an account?
brooks
tables to fields . . .
Hi. I'm taking some tables in a .doc and putting them in a custom object.
It seems to me that the best way to do that is use a logical naming convention for each field that represents a cell.
Here's an example:
The table in my .doc is called "Doors." And the column headers are "Name," "Area," "Type," and "Location."
So, I'm calling the first set of fields, which correspond to the first row in the table, the following:
"Door Name," "Door Area," "Door Type," "Door Location"
And the second set of fields, which correspond to the second row in the table . . .
"Door Name 2," "Door Area 2," "Door Type 2," "Door Location 2"
. . . and so on for however many rows are in the table.
Is there a more elegant way to do this? Obviously, each field has to have a unique name or you would have no idea what you're doing when you run a report. But I thought I'd run it by this thundering herd.
Thanks for any feedback.
It seems to me that the best way to do that is use a logical naming convention for each field that represents a cell.
Here's an example:
The table in my .doc is called "Doors." And the column headers are "Name," "Area," "Type," and "Location."
So, I'm calling the first set of fields, which correspond to the first row in the table, the following:
"Door Name," "Door Area," "Door Type," "Door Location"
And the second set of fields, which correspond to the second row in the table . . .
"Door Name 2," "Door Area 2," "Door Type 2," "Door Location 2"
. . . and so on for however many rows are in the table.
Is there a more elegant way to do this? Obviously, each field has to have a unique name or you would have no idea what you're doing when you run a report. But I thought I'd run it by this thundering herd.
Thanks for any feedback.
The method is not appropriate and does not follow the basic guidelines for database design.
A table is a collection of records with the same structure - as is an object on the Force.com platform. Each row of the table in your document has the same structure, so they should be records in an object.
Typically, naming convention calls for the object to be named Door (or Doors, depending on preference), and the fields to be named Name, Area, Type, etc. - you will always be referencing the fields in the context of the table, so no sense repeating the identifier.
If you could convert the table in the document to an Excel spreadsheet, you could use the data import tool or Data Loader to load the values into a Force.com object.
Hope this helps.
Thanks for responding.
Yes, I agree that a single table should be translated into an object.
In this case, I have multiple tables (in the .doc) that are part of a larger set of data that is in the object. But good database design still dictates that I break those tables out into separate objects, I suppose.
I've not run reports across so many objects at once - call it 15 - am I going to experience any limitations?
Thanks,
Brooks
Will you run into reporting limitations? Probably. The absolute limit for number of objects in a custom report type is 20, but are you actually going to have all 15 object joined in relationships?
If the tables are part of a larger set of data, create an object to represent that larger set of data. This is a much more straightforward way to handle what I understand about your situation.
Thanks for the feedback.
Just wanted to make sure that was clear.
Standard Object -> Master Object -> Child Objects.
We've been talking about the Master to Child relationships. I didn't mention the Standard object that was part of this, which is partly where my concern about reporting comes from.
Meaning, there is no "grandfather" reporting that incorporates the data in the child of a child.
Nor can you report on "spiders" or multiple child objects off a primary object.
Obviously, it isn't intuitive to have limits on reporting on what is one set of data even though subsets of that data reside in different objects.
That's no excuse for thinking of implementing an ugly hack, but . . .
You should explore this and other options before you go denormalizing your object structure. You may end up having to do so, but this type of design is a workaround, at best, and as such frequently causes other problems down the road.
Yes, now I know about adding fields from a grandfather object via a new Report Type, so that I can report on a parent-child object and have fields from the grandfather.
So, a good workaround . . .
Overall, the approach you choose will depend on the specific requirements of your project and the tools and technologies you are working with. However, with careful consideration and planning, you should be able to come up with a naming convention and data structure that meets your needs and is easy to understand and maintain. Source https://qsmart.qa/services/av-solutions-company-in-qatar/