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

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
  • (Edited)
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.g
001
002
003
004
005
006
007

When 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. 

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.
Photo of Samuel Goh

Samuel Goh

  • 222 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
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.
Photo of Samuel Goh

Samuel Goh

  • 222 Points 100 badge 2x thumb
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!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
No problem. Just make a report of batteries with excessive usage and put that report on your homepage.
Photo of Samuel Goh

Samuel Goh

  • 222 Points 100 badge 2x thumb
How do i make a prompt/indication if the value goes above what i have set?
Photo of Samuel Goh

Samuel Goh

  • 222 Points 100 badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
I suggest using row colorization.

https://help.quickbase.com/user-assis...
Photo of Samuel Goh

Samuel Goh

  • 222 Points 100 badge 2x thumb
hi, how do u change between numeric(reference) and text(reference) without screwing up the existing relationship between the various sheets?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
I suggest that you post this as a new question and explain your relationships and the field you want to change.