Skip to main content
Solved

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

P

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.

 

 

Best answer by DisraeliGears01

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. 

View original

    3 replies

    Mike_AutomaticN
    Forum|alt.badge.img+9

    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
    Forum|alt.badge.img+18

    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
    Adam, Consultant @ The Time Saving Co
    DisraeliGears01
    Forum|alt.badge.img+6

    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. 

    P
    MJen
    2 people like this
    • P
      Paul_Thompson
    • MJen
      MJen

    Reply


    Most helpful members this week

    Terms & Conditions