TOPIC:

Ready filled tables 05 Oct 2011 14:01 #108

Kevin Topic Author Visitor	When I build a table to use for a drop down menu eg Mr, Mrs,Ms or Monday Tuesday Wednesday etc, it would be nice to be able to add this data into the component. That way it will me ready to go when installed. Sorry should have put this in new functions [MOVED]
	Please Log in or Create an account to join the conversation. Last edit: by admin.

Re: Ready filled tables 05 Oct 2011 17:15 #109

zutiste Offline New Member Posts: 18 Thank you received: 1	For lists like Mr, Mrs you can use the enumeration data type
	Please Log in or Create an account to join the conversation.

Re: Ready filled tables 05 Oct 2011 17:53 #110

griiettner Offline Senior Member Posts: 73 Thank you received: 12	zutiste Can you give an example of how to use the enumeration... because last night was trying to find a good use ofr it, but I still did not get it... thanks Paulo Griiettner
	Please Log in or Create an account to join the conversation.

Re: Ready filled tables 05 Oct 2011 18:07 #111

zutiste Offline New Member Posts: 18 Thank you received: 1	well, not sure I understand your question because it looks very simple to me. for example, a table with first name and last name. you can add an enumeration field with the values "Mr, Mrs, Miss". just edit the field to specify the values. I guess it's good for values that won't change.
	Please Log in or Create an account to join the conversation.

Re: Ready filled tables 05 Oct 2011 18:14 #112

griiettner Offline Senior Member Posts: 73 Thank you received: 12	If I understood right... I could use it to make to fields like "Pending", "Canceled" and "Sent" for orders for instance? If that's the use of this field, I think is nice... Paulo Griiettner
	Please Log in or Create an account to join the conversation.

Re: Ready filled tables 06 Oct 2011 05:26 #114

zutiste
Offline
New Member
Posts: 18
Thank you received: 1

yes, correct.

- if the data won't change
- if there is no extra information associated to the data

ie :
-> "Pending", "Canceled" and "Sent" is set for eternity and does not need any extra information
-> List of prices : it might change
-> List of countries : there might be associated information like biggest cities, international country calling code, time zone, etc

The following user(s) said Thank You: griiettner

Please Log in or Create an account to join the conversation.

Re: Ready filled tables 06 Oct 2011 06:01 #115

griiettner Offline Senior Member Posts: 73 Thank you received: 12	Thanks mate... I got it now... I found a good use for it now... I was doing in another way, but using this feature, makes things easier... Paulo Griiettner
	Please Log in or Create an account to join the conversation.

Re: Ready filled tables 06 Oct 2011 08:13 #116

Kevin
Topic Author
Visitor

Nice one zutiste this has made life so much easier.
I was using the foreign key method to show info from another table.

The problem I had with foreign key was, the id was stored in the database instead of the value.
i.e Mr=1 Mrs=2 Ms=3.

I want to be able to export the data to an excel file so that would have been a problem./

Very happy I asked the original question now or I wouldn't have learned this.

Karma added, cheers

Please Log in or Create an account to join the conversation.

Page:
1

Forum

Ideas & Suggestions

New functionalities

Ready filled tables

Time to create page: 0.130 seconds

“

”

Let me first state that this is an amazing and fascinating product exactly what I was looking for. In just a few hours (listening to the very well made and clearly understandable videos learning doing) I completed and installed my first component. I am now in the second refining phase. I will make a recommenation in JED. Thanks for the effort in creating such a great product. Incidentally some of the best Joomla extension I use are of French origin !
Giori (Forum)