mutiple choice with multiple selection, multiple X values in pie chart

Question

Hi all,I'm new in the platform and would like to explore several capabilities of this platform.Currently, I have issues in trying to manage the following issues:I want to be able to log multiple Serial Numbers of my battery used for an operation. (3 is used at 1 time) Hence, I could only create 3 different fields for [Battery S/N 1], [Battery S/N 2], [Battery S/N 3]hence in my multiple choice, there are several options.E.g001002003004005006007When I try to build up a pie chart, I could only choose the X- axis to either be [Battery S/N 1], [Battery S/N 2] or [Battery S/N 3]. I want to be able to build a pie chart which can evaluate the total number of hours used by each battery so I can have a clear understand which one would require maintenance, etc.&nbsp;Additionally, I would want the system to prompt to my homepage whenever a Battery S/N reaches 50hours for example, how do I go about doing that?Would appreciate any help asap!Thanks.

quickbasecoachd · Answer

You should have a table of Batterues
You should have a table which records when the machine is used.
Then the machine table needs to have a child table with the three battery Assignments used for that usage and you will lookup the hours used from the Parent Record.

Then you can run all kinds of statistical reports.

archiveuser · Answer

Hi. Thanks for the clarifications! I've got it sorted out after reading your comment.

Are there any ways I could set a notification to pop-up on my home screen?

For example, if the batteries are used for a total of 30hours, a pop up appears on the home screen to notify me upon reaching the no. of hours required to send for maintenance.

Thanks!

quickbasecoachd · Answer

No problem. Just make a report of batteries with excessive usage and put that report on your homepage.

archiveuser · Answer

How do i make a prompt/indication if the value goes above what i have set?

archiveuser · Answer

I've Made a simple formula to indicate certain texts,

If([Total Flight Time]<=100, "Green",

If([Total Flight Time]<150,"Yellow","Red"))

However, instead of just texts i want an image of [Red],[Green] & [Yellow]. Is that possible?

Thanks.

Forum Discussion

mutiple choice with multiple selection, multiple X values in pie chart

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

How to consolidate multiple rows into one

Modify multiple rows within the same group using Single Record ?

Building a report from multiple tables