Is there a way to populate a form with fields from a connected parent record BEFORE the form is submitted?
I’m building a multilingual app that uses fields from a “Language” parent table to translate labels to the user’s language. The Language contains the translations, for example:
LANGUAGE TABLE (PARENT)
Language | name_label | email_label
English | Name | Email
French | Nom | Courriel
CHILD TABLE - “Add new” form
If the user is English, the form would display:
But if the user is French, the labels would change to:
The closest I could get is to setup this rule in the child table:
On Create/Edit, Set [Connection field] to Logged in User’s Field [Language]
This rule does create the connection to the parent record but the “labels” are only displayed AFTER the form has been submitted which doesn’t work for me since the user needs to see the labels when filling-out the form. A 2-step form could work by doing the connection in step 1 and displaying the labels in step 2 but the user would have to click a button on an empty form in step 1.
Any ideas? Maybe there’s a way to do this using JS?