Set a connected record using a calculated field

[TootsieTor35028]

I have an object that has a calculated (text) field which results in the same text as a connected field. I would like to dynamically connect the original record with the corresponding connected field based on the results of the calculated field.

I have tried doing this on record creation and/or record edit, but the calculated field does not come up as a form input so I can’t set the value of the connected record using field value.

Does anyone have any other solutions to this? I assume I could probably do this with Zapier, but I’m wondering if it is possible to do natively within Knack.

[StephenChapman]

Hey again @TootsieTor35028!

Nothing native unfortunately, but I’d either take it to Zapier/Make, or build a function that runs after submitting the form that gets your GL String, and does a GET API call to find your respective LU_GL Account Number from another table with a dynamic text comparison filter, and then PUT into that same record if an account number was found.

Hope that steers you in the right direction.