Forum Discussion

NelsMcLaughlin's avatar
NelsMcLaughlin
Qrew Member
12 months ago

Create event every two weeks

I am creating a calendar for a Program my company has where I want to add in a record for each pay day, that happens every two weeks. Its a very simple calendar setup - currently I only have three fields in each record - Date, Date Type, and Description.

What I want to do is only enter the first Pay Date and then have QB duplicate that record every other Friday. Id probably have to put an end date on it so that it doesnt go on forever and I have endless records (I could be wrong here)?

Automations doesn't exist anymore and I have a hard time with Pipelines as I'm a video professional by trade. Any help would be appreciated.



------------------------------
Nels
------------------------------
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    12 months ago

    The best recommendation is to avoid trying to automate it and just import via excel. Since time is a pattern that never changes - you can just prepopulate the next 5, 10, 15 years worth of dates in Excel and load that into your system via manual import. 



    ------------------------------
    Chayce Duncan
    ------------------------------
    • NelsMcLaughlin's avatar
      NelsMcLaughlin
      Qrew Member
      12 months ago

      I figured this would be the way to do it. Thank you for your help!



      ------------------------------
      Nels McLaughlin
      ------------------------------