I have been playing with Cobalt 8 for a few days, and so far I've been able to figure out everything I need it to do... It's great.
But... one thing I'm not sure if it's possible, or if it's easy to do, is this:
I have created a TYPE called "Sore", for example. Inside, there are several fields, such as "Apples", "Oranges", "Bananas", and "Pineapple". The user would type in a number in each field, so that there is a record of how many apples, oranges, that this store has. The user saves it and the record is saved.
Is there a way, when displaying the record to the website visitors, to automatically add up the number in each of the apples, bannans, fields fro this one record, and show the total number? For example, "This store has 12 fruits in total"? (I don't need to add up the totals from all the records, I juist need it added up from inside each "Store" individually.)
Basically, I want there to be several user-entered number fields, but then one field that can't be edited that will automatically add up the number and display the total?
How can this be achieved?
(Please note, I have very limited PHP and SQL knowledge, although I can guess that this could be done by using a custom template and then using SQL to find and calculate the number, however that is beyond my knowledge, while I know it's possible I have no idea how. I'm hoping there is a special field type I can buy or download that will do this much easier!)
Thank you!
Question
Announcement
Conversation
Idea
Praise
Problem
Reviewed
Open
I have been playing with Cobalt 8 for a few days, and so far I've been able to figure out everything I need it to do... It's great.
But... one thing I'm not sure if it's possible, or if it's easy to do, is this:
I have created a TYPE called "Sore", for example. Inside, there are several fields, such as "Apples", "Oranges", "Bananas", and "Pineapple". The user would type in a number in each field, so that there is a record of how many apples, oranges, that this store has. The user saves it and the record is saved.
Is there a way, when displaying the record to the website visitors, to automatically add up the number in each of the apples, bannans, fields fro this one record, and show the total number? For example, "This store has 12 fruits in total"? (I don't need to add up the totals from all the records, I juist need it added up from inside each "Store" individually.)
Basically, I want there to be several user-entered number fields, but then one field that can't be edited that will automatically add up the number and display the total?
How can this be achieved?
(Please note, I have very limited PHP and SQL knowledge, although I can guess that this could be done by using a custom template and then using SQL to find and calculate the number, however that is beyond my knowledge, while I know it's possible I have no idea how. I'm hoping there is a special field type I can buy or download that will do this much easier!)
Thank you!