Someone suggested that there is a way to allow custom fields based on view that is not in the database. This will allow users to add some additional fields. Is that possible? Anyone know how?
Custom Fields
-
- User
- Posts: 140
I am speaking about something a little different. Lets say an agent wants to create some custom fields on the fly. For example:
Table: Customer
Fields: Name, Email, Phone, Custom1, Custom2, Custom3
Now I want agent to be able to define those custom fields with for example: Wifename, Wifeemail, Wifephone
Then when he adds data he will get instead of custom...wife....
The agent can define he own custom values for fields.
-
- User
- Posts: 11905
This actually can be achieved by designing your tables which can be related between one to another by using "one-to-many" relationship.
For example, you can link your "Customer" table to the "CustomFields" table (for example) that contains the custom fields that belong to the certain user. You can then create a database View to get the information from both the tables, so that the view will contain the fields you mentioned earlier.
For input new record Add page, then you can use "Master/Detail Add" feature. The same way also for Edit page, use "Master/Detail Edit" feature.