Default field value inherited from parent

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
I have a parent table called "Requests" and a child table called "Request Items."  In the Request Item table, there is a field, "Billable?"  For any particular Request, the related Request Items would all be either "Yes" or "No" in the Billable field.  If this were always the case, I know that I could just put the "Billable?" field in the Request table and do a lookup on the child Request Item records. 

However, there are sometimes exceptions where some of the items are Yes and others are No on the same request.  

Question: I would like to put the "Billable?" field on the parent and also "Billable?" on the Request Items table.  The value of the "Billable?" field in the parent would become the default value of the "Billable?" field in the child Request Items record. So that user could change that value for each child Request Items record if needed.

Is this possible?
Photo of Anthony Guillen

Anthony Guillen

  • 320 Points 250 badge 2x thumb

Posted 6 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
No problem, you just make a formula for a field called [Billable]. Lets assume that it will calculate to Yes or No

IF([Billable Override]<>"", [Billable Override], [Billable lookup from Parent])
(Edited)
Photo of Anthony Guillen

Anthony Guillen

  • 320 Points 250 badge 2x thumb
ahh, perfect!  Thanks!