Forum Discussion

ChyanneEyde's avatar
ChyanneEyde
Qrew Trainee
4 years ago

Automation - Trying to "copy value from another field" but no options for values appear

I am setting up an Automation in which the action fills a field using the option "copy value from another field." The field I am trying to fill is a date field named "Date Immediate Needs Addressed". When I try to specify a value nothing appears. I am sure I am missing something obvious, but after reading through QuickBase guidance I'm still unsure. (I've also tried choosing other fields under Field, but still no options appear under Value.)

Thoughts? Why can't I select a Value? 



------------------------------
Chyanne
------------------------------
Quickbase Automations
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Is this a Scheduled Automations and you are trying to populate a field on each filtered record from another field on the same record?

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • ChyanneEyde's avatar
      ChyanneEyde
      Qrew Trainee
      4 years ago
      I think that's a fair summary. I am trying to identify certain records and then edit one field on those records. 

      I am filtering for records in which the [# of Immediate Needs NOT] = 0 AND [Date Immediate Needs Addressed] = <blank> (I temporarily put a date instead of blank). I want to then put a date in the field [Date Immediate Needs Addressed].

      ------------------------------
      Chyanne
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        Right, so I have run into this exact same problem myself. If the automation had a trigger record then the fields from the trigger record would be available. But because it is a scheduled automation there is no trigger record.

        So I think there are two alternatives. One is to set up a saved table to table copy with those same filters on white records need to be updated and have the scheduled automation run that on your schedule.  It remains to be seen what QuickBase plans for us when it comes to the migration of automations for running saved table to table imports. But at a minimum it will be possible to manually convert that automation by calling the API in the pipeline. 

        The other alternative  would be to have an automation update each of those records and apply a checkbox to a certain field. Then you can have another automation the triggers when the checkbox is changed to do the actual update you were looking for. Since the second one will be based on a trigger event rather than a schedule you will find that the fields from the trigger record will be available to you.

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------