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.