Forum Discussion

GregSchroeder's avatar
GregSchroeder
Qrew Trainee
7 years ago

Need to add 40 to the a numeric field value after a certain number of days pasts in another date field. Can anyone please help! Thanks!

Hello,relatively new to quick base here. I'm trying to track my employees available vacation time in a field AND automatically add 40 days to that field after their start date reaches 2 years ago ( 730 days ). With a dynamic form rule I can select when Start date is equal to itself plus 730 days, but I can't figure out the action to simply add 40 days. I can select change, available vacation time, but from here can't figure a way to add 40 to the original number in the available vacation time field. Can anyone please help! Greatly appreciated!  Thanks!
Forms
Quickbase Automations
Tables and fields
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    This should not be done with Dynamic form rules as they only fire when a record is being editing by a human, and not via the passage of time.

    You should use a formula which calculates the vacation time based off the start date of the employee.

    Can you state in words what the vacation policy calculation is?



  • GregSchroeder's avatar
    GregSchroeder
    Qrew Trainee
    7 years ago
    Year 1-2 10 days (80 hours)
    Year 3-5 15 days (120 hours)
    Year 6+ 20 days (160 hours)
  • GregSchroeder's avatar
    GregSchroeder
    Qrew Trainee
    7 years ago
    up to 3 years from start date = starts with 80 hours
    after 3 years  from start date = ( add 40 hours ) 
    after 6 years  from start date = ( add 40 hours ) 
  • GregSchroeder's avatar
    GregSchroeder
    Qrew Trainee
    7 years ago
    The names of the two fields I'm working with are "Start Date" and "Available Vacation Time"
    Any help is greatly appreciated!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Not tested but try this

    IF(
    Today() >= AdjustYear([Start Date],6), 160,
    Today() >= AdjustYear([Start Date],3), 120, 80)
  • GregSchroeder's avatar
    GregSchroeder
    Qrew Trainee
    7 years ago
    I think it worked... I can no longer edit the available vacation field and it looks like it has the correct values for my employees... Thanks!
  • GregSchroeder's avatar
    GregSchroeder
    Qrew Trainee
    7 years ago
    wait, the employees with between 3-5 years isn't displaying as 120... they are showing as 80 hours like the ones between 1-3 years
  • GregSchroeder's avatar
    GregSchroeder
    Qrew Trainee
    7 years ago
    shoot this won't work anyway... sorry because after they take time off we need to be able to subtract hours from this fiend and it's not editable right now.   I'm sorry like I said, learning
  • GregSchroeder's avatar
    GregSchroeder
    Qrew Trainee
    7 years ago
    Anyway just on the 3 and 6 anniversary dates 40 can be added to those fields ( regardless of what's in them at the time ) and keep the field editable so they can subtract time as it's used?