Welcome to the community, @Eric_Shank1! :grinning_face_with_big_eyes: There’s a new scripting action beta feature that could probably help. It can be triggered by a new record being added to a table, which would be the [Answers]
table in your case. The new record could be sent to the script, which would check the [Questions]
table to see which view is active (using the newly-added cursor
feature) and update the new [Answers]
record appropriately. (I just read about this new cursor
option earlier today, and the docs say it’s for the scripting block only, so I’m not sure if that also includes the scripting action beta. I don’t have time right now to run a test, but I’ll do so tomorrow and report back.)
EDIT: I ran a quick test, and it doesn’t appear to work in the scripting action beta, even though cursor
shows up in the API docs inside the script editor for the beta. I’ll have to report this oversight. It looks like the active table and view info is only available in the scripting block, where scripts must be manually triggered. With that in mind, you could make the link and add the new record, and then trigger a script to find that new record and update it accordingly. That’s probably the best you can do at this point.