Skip to main content
Solved

Rollup for patient treatment


Forum|alt.badge.img+3

Hello!
I have built a database to record a patient’s treatment.
I have shared with him a form to introduce the pills he takes… .but I still have to add up the number of tablets he takes in a day, a week or a month….
I have tried with sum and rollup formulas … BUT I DON’T KNOW HOW TO DO IT!
Could you help me get it?
What steps should I follow…. What can you think of?
I could even share my database with some of you to help me make this column, sum, sum or rollup….

THANKS A LOT.

Best answer by Hugo_Mongay

Hugo_Mongay wrote:

I did it !!!
THANKS A LOT!!!

I love airtable!


So, I did it, readding

Count only specific multi-select items in one record

with your answer…

Thanks Mo!!!

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+17

Hi @Hugo_Mongay,

Welcome to Airtable Community! :grinning_face_with_big_eyes:

You can do a rollup and set it to CountA, that is correct. What a rollup does is Count the number of records In a linked field.

BR,
Mo


Forum|alt.badge.img+3
  • Author
  • Inspiring
  • 8 replies
  • April 29, 2020
Mohamed_Swella1 wrote:

Hi @Hugo_Mongay,

Welcome to Airtable Community! :grinning_face_with_big_eyes:

You can do a rollup and set it to CountA, that is correct. What a rollup does is Count the number of records In a linked field.

BR,
Mo


I did it !!!
THANKS A LOT!!!

I love airtable!


Forum|alt.badge.img+3
  • Author
  • Inspiring
  • 8 replies
  • Answer
  • April 29, 2020
Hugo_Mongay wrote:

I did it !!!
THANKS A LOT!!!

I love airtable!


So, I did it, readding

Count only specific multi-select items in one record

with your answer…

Thanks Mo!!!


Reply