Discussions

Expand all | Collapse all

Troubleshooting an automation

  • 1.  Troubleshooting an automation

    Posted 12-30-2019 17:15
    Any advice on how to troubleshoot an automation?  I got this error and know which automation it is but it does not indicate at all what the issue was.  It just takes me to the automation.



    ------------------------------
    Ivan Weiss
    ------------------------------


  • 2.  RE: Troubleshooting an automation

    Posted 12-30-2019 18:13
    The error message says that there is a required field and you are not populating it.  So look at the field list to see which fields are required. They will have a red star.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Troubleshooting an automation

    Posted 12-30-2019 18:32
    Sorry should have posted this as well.  All of the red asteriks fields are populated:



    ------------------------------
    Ivan Weiss
    ------------------------------



  • 4.  RE: Troubleshooting an automation

    Posted 12-31-2019 06:57
    Edited by Mark Shnier (YQC) 12-31-2019 07:00
    Perhaps  the particular source Record has blanks in  Title or Type

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Troubleshooting an automation

    Posted 12-31-2019 10:45
    Ivan,

    When did the fields become required? You may have gaps.

    More than once I have had optional fields evolve into required fields as the business case grows more sophisticated.  Then you have older data that is valid but incomplete.  Reports, automatons and workflows then do not work correctly because of the legacy issue.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 6.  RE: Troubleshooting an automation

    Posted 12-31-2019 16:24
    I am not sure exactly when might have been required.  But if I go into the source table it looks like all of those fields are complete which is why I am really confused about this.

    They give you so little troubleshooting information I am having a hard time spotting the issue.

    ------------------------------
    Ivan Weiss
    ------------------------------



  • 7.  RE: Troubleshooting an automation

    Posted 12-31-2019 16:40
    What are the criteria and filters?

    ------------------------------
    Jason Johnson
    ------------------------------



  • 8.  RE: Troubleshooting an automation

    Posted 12-31-2019 16:42
    You could unrequire the fields one by one to determine which field is the problem.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 9.  RE: Troubleshooting an automation

    Posted 01-03-2020 09:04
    I found it, it was one entry in the tasks template table that got added before one of the fields was marked required so it got missed, 1 out of 262 lol

    thanks for the help

    ------------------------------
    Ivan Weiss
    ------------------------------