Skip to main content
Question

Date Help

  • August 30, 2023
  • 0 replies
  • 23 views

SaviNewman1
Forum|alt.badge.img+6

Hola,

My company inputs water samples, for our tasks.

There is a relationship between the two. 

Like, the task name so it connects to the task overview. 

Within the water sample, is a field to input the date the sample was taken.

We need that date, to display on the task labeled "Nitrate Sample Last Taken" and it displays the date from the water sample on the task IF it was a nitrate.

Can you help?



------------------------------
Newman, Savi
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

No problem. You have a relationship where one task as many water samples.  

Just go to that relationship and on the left side, make a summary field of the maximum of the date field subject to a filter where the Type was nitrate.  



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------