Automation to update a long text field with the value in a computed field.

[Paul_Thompson]

I need to pull some data from a computed field (actually a filtered lookup field) in Airtable to prefill a form in Jotform. It should be easy as Jotform have introduced the feature (bizarrely under the publish menu) but despite several ways of trying, it will not map to computed fields.
My inteded workaround is to map it to a long text field which an automation would update with the value from the lookup field, triggered if the lookup field is not empty. On mapping the fields in the automation, Airtable greys out the lookup field {Instruments} reporting the same issue as occurred whilst trying to mp directly from Jotform, that the field cannot be used because it's computed.
I've spent a whole week on this. I've tried converting to text, using a string, an array, and concatenating, but of course, they all need computed fields to hold and reference them.  Anyone know a workaround?

Post edit/after thought....Perhaps I can use a script with the same trigger but I'm not really a scriptor.

 

[Mike_AutomaticN]

Hey! I’m on my phone so I cannot really play around with alternatives and I might be missing smth. 

But you might want to try creating a new formula field called “String: Instruments”, and just make the formula reference the lookup {Instruments}. Then check if you can map String: Instruments on the automation. 

I’ll try to get back to this later from my computer :). 

Mike, Consultant @ Automatic Nation

[TheTimeSavingCo]

Hmm your idea for the workaround should work, and I think I got it running okay

Link to base

If you're still facing issues I do free half hour calls and we can hop on and sort it real quick, and you can grab a time here

---

If possible, I'd suggest just using Fillout instead, really.  Simpler to use (to me, anyway) and has this functionality out of the box without you needing to do all this automation stuff

[DisraeliGears01 · Accepted solution]

I replied in another thread, but the pictures here make it much clearer. 

Your problem here is that you're clicking the blue "Choose Field" prompt rather than the blue + to add the Instrument lookup field in the "Instrument Text" field.  You should remove the Airtable RecordID text from that field (unless you want it to say recXYZ123XYZ123 Flute) and replace it with your lookup.