Questions tagged [user-defined-fields]

22 questions
158
votes
14 answers

How to design a database for User Defined Fields?

My requirements are: Need to be able to dynamically add User-Defined fields of any data type Need to be able to query UDFs quickly Need to be able to do calculations on UDFs based on datatype Need to be able to sort UDFs based on datatype Other…
Rachel
  • 130,264
  • 66
  • 304
  • 490
14
votes
4 answers

What is key Path in user defined runtime attributes?

I have inherited a project and i'm confused on what a certain key is. My question is, what is the styleName key Path ? is it a property to the view ? How can i find out what key Paths are available ? For example, after i select a UILabel from the…
j2emanue
  • 60,549
  • 65
  • 286
  • 456
6
votes
3 answers

How would you create and store user-defined custom fields in a SQL database?

I need to allow users to add new fields to a record, e.g. if there is a Contact record, a user may want to add a "SSN" numeric field and a "Birthdate" date/calendar field. They would do this through the UI of course. Those fields should then be…
Alex
  • 75,813
  • 86
  • 255
  • 348
3
votes
1 answer

How to design a database for User Defined Fields(UDF)?

I am working on an application which will require one or more additional fields to be added to a table in order to track user defined information. This additional info is only used for reporting purposes(Crystal Reports), and will have no effect on…
3
votes
2 answers

Creating extended property using EWS and access it from Outlook Add-in

I am currently working on EWS to have some integration of our company application with Exchange 2010. I am using EWS to create appoinment to Exchange 2010 and it works fine; but recently I tried to add some custom/extended property when creating…
3
votes
1 answer

Found and Set Value to a UDT member VB6

I'm looking for some help to solve a problem with dynamic set values of the UDT members. I'm trying do something like the pseudocode ahead: Public sub UDTMemberSetValue(ByRef pvUDTValue As Variant, _ ByVal psMemberName…
3
votes
2 answers

Building Word fields

Apart from just inserting and parsing text into a blank Word field, is there any way to programmatically build user-defined fields and field codes into my own templates with VBA? Furthermore, is there a way to make these fields show up in the list…
JonnyGold
  • 861
  • 6
  • 15
  • 20
3
votes
1 answer

How best to create custom fields per user/customer?

I've got an application which is sold as a SAAS to multiple customers. Predictably, sometimes customers want to customise some areas of the application by adding their own fields, specifically the area relating to Action/Project tracking. We allow a…
Robin
  • 2,616
  • 22
  • 30
2
votes
3 answers

What is the fastest method for performing more than 64 table joins in SQlite?

I'm planning on generating queries for SQLite that will involve many joins on 12 tables that will surpass the 64 table join limit in SQLite. (~250 table joins or possibly more) This will be running on android eventually. The purpose behind this is…
Biff MaGriff
  • 8,102
  • 9
  • 61
  • 98
2
votes
1 answer

Entity Framework 6 tablename as FK value

I have following two DB tables. The purpose of "attributes" table is to provide user the ability to introduce more fields for existing tables at the runtime. So all user-defined attributes for all tables will be stored in one "attributes" table.…
2
votes
1 answer

Crystal Reports 8.5 grouping

I am grouping using a formula fCity which goes like this If {X.MailingCity} > "" Then {X.MailingCity} Else {X.City} I have two different fields in my view (Home City and Mailing City) Now, these fields contain many rural communities and in my report…
Ruby
2
votes
1 answer

reading user define build setting in xcode

I have a user defined variable called "ENVIRONMENT" I have a plist with this entry Environment = ${ENVIRONMENT} in my xcconfig: ENVIRONMENT=Dev I also set the configuration file for the project to see my xcconfig file. I know this part works…
Nick Turner
  • 927
  • 1
  • 11
  • 21
1
vote
1 answer

Accessing User Defined Fields in Outlook

So, I have a custom email form/message like below and I want to access the "Doc Title:" field value to insert it into the body of the email. I currently have this code; Function Item_Send() Item.Body = Item.Body +…
Trent
  • 1,595
  • 15
  • 37
1
vote
1 answer

Design patterns for user defined fields with dropdownlist support

I have an application that supports user defined fields for my customer table, and I already have something like this: CustomFields table Id Name DataType -------------------------------------------- 1 …
Null Reference
  • 11,260
  • 40
  • 107
  • 184
0
votes
1 answer

Google contacts API is ignoring the userDefinedField setting

I am trying to add a contact while at the same time including a userDefinedField. The code below works and adds the contact with the correct information however the userDefined field is missing. If I purposefully misspell one of the attributes, when…
1
2