Automation Missing Field

Question

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.&nbsp;

Thank you,Kim------------------------------Kimberley------------------------------

markshnier__you · Answer

Is this a new field recently created?&nbsp; 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

andreapahor · Answer

This has happened to me.I closed and reopened the automation and the field appeared after a small lag.------------------------------Andrea Pahor------------------------------

donlarson · Answer

Kim,I have had Special Character problems plenty of times.&nbsp; &nbsp; I suggest you create a brand new field in both tables and use that in your automation.&nbsp; 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 LarsonPaasporterWestlake OH------------------------------

kimravizza · Answer

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
------------------------------

markshnier__you · Answer

God tip for the rest of us.&nbsp; Pretty obscure.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

Forum Discussion

Automation Missing Field

Related Content

Table is missing

Missing Records/Data Issue

Missing an option in Kanban Card Groups

Missing NetSuite Custom Fields

View icon missing from reports