Is there a way of using number from TOT (total) column in a formula (from relationship table)?

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered
Is there a way of using TOT (total) column in a formula? I have one field that shows a specific number, and have created a relationship with another table (that in this case shows number of delays). In that delay table, bellow I see a number in TOT column, but I don't know how to use that number in a function.
Photo of Nenad Ilic

Nenad Ilic

  • 120 Points 100 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,320 Points 50k badge 2x thumb
This (Tot) values are not available to use in Formulas fields, they only exists on the report. But if you describe your tables and relationships and what you are trying to do, there still may be a way to get there.
Photo of Matthew Neil

Matthew Neil

  • 31,678 Points 20k badge 2x thumb
(My Hunch)

If your Child table is called 'Delays' I'm going to assume your parent table is something like "Projects".

To get that total value that appears in the embedded delay report, usable in a formula, you will need to make a summary field.

In the table settings, find the relationship between the project and the delays
>
Click "Create Summary"
>
Select "Total" and the field (i.e. Duration)
>
Create and name as you'd like

Then you should be able to use wherever you'd like.
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
If I wanted to use that total to populate into a badge on a rich text page, where would I retrieve that formula? I assume I would use a query, but I want to know how I can pull it without the grid box around it. I just need the number.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
You can extract any content from any QuickBase page and insert it anywhere in a code page with this technique.

Here is a summary report where a total of 631 is displayed:




https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=q&qid=89

If you create a RichText page and enter HTML editing mode you can get the total to appear with a short bit of code:


Here is the result:

mypage.html
https://haversineconsulting.quickbase.com/db/bgcwm2m3z?a=dbpage&pagename=mypage.html


Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=659

Notes:

(1) See $.load() for details:

http://api.jquery.com/load/
(Edited)
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
Thanks, Dan. The total was pulled in, but when I created a new record, it did not update the total. What am I missing?  
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
I take that back... it's updating the number in the code, but I'm trying to embed it in a badge, and that's the number that isn't updating.
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
Aaand... I got it! Thank you :)
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
Nope... false alarm. What part of the code do I embed into the badge?
Photo of Kelly

Kelly

  • 1,812 Points 1k badge 2x thumb
Ok, I don't mean to toy with your emotions, but I have it now! This is going to come in very handy... thanks again!