Forum Discussion

NataliaVolochin's avatar
NataliaVolochin
Qrew Member
4 years ago

Is there a way to copy several formula fields to create new (still formula) fields?

based on specific fields, I need to create the formula fields x month from Jan 2017 until Dec 2021 (for now :) 
I've done them for 2017 (and it took a while :) )
Is there a way to copy all the 12 existing for 2017 to replace 2017 references with 2018 ones afterward?
Thanks in advance

------------------------------
Natalia Volochina
------------------------------
Formulas and functions

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    If you are asking if there is an automatic way to create formula fields, then answer is no.  You will need to edit the existing fields or copy them to make new fields.

    But you may want to consider redesigning your app so as not to need hard coded fields like that.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      If you wanted to rethink that structure on this Forum, you can describe your setup.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • NataliaVolochin's avatar
        NataliaVolochin
        Qrew Member
        4 years ago
        Dear Mark,
        thank you for challenging me! (had enlightenment at night)
        BR
        NV

        ------------------------------
        Natalia Volochina
        ------------------------------