Skip to main content
Question

Automation Missing Field

  • November 26, 2019
  • 0 replies
  • 35 views
Forum|alt.badge.img+9
Hello,

I've created an automation to copy records from a template table to a line item table. For some reason, one field from my line items table does not show up to select when I'm creating the copy action in the automation. All the other fields I need are there and are copying over. I've checked both tables and the field exists in both. I've never seen this before. Any thoughts? The field I'm looking for is "Recommended Buffer %" and it is not included in the available fields. I thought maybe it was because of the special character, so I removed it, but I still don't see the field in the drop down. 



Thank you,

Kim

------------------------------
Kimberley
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • November 26, 2019
Is this a new field recently created?  If so I would log off all your sessions and log in again and then the Automation might see the new fields.

If these are "old" fields, then that is a more difficult question.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+15
  • DonLarson
  • Quickbase Alumni
  • November 26, 2019
Kim,

I have had Special Character problems plenty of times.    I suggest you create a brand new field in both tables and use that in your automation.  If that fixes the problem then you know that somewhere in the Secret Sauce of Quick Base the old field name and its issues have not cleared.


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Forum|alt.badge.img+9
  • KimRavizza
  • Author
  • Quickbase Alumni
  • November 26, 2019
Doh! I figured it out. I had restricted access to the field to "View" for all roles. Changed it to "Modify" for admin and the field appeared in the automation.

Thanks so much for all your thoughts. Much appreciated :)

Kim

------------------------------
Kimberley
------------------------------
Terms & ConditionsAccessibility statement