Hi all,
I have a table with 3 bases. The first- Base A- has a list of articles and a field “Article ID”. Base B is a list of people being assigned to a specific article, with different fields describing that person (name, email, affiliations, etc) and each record has a field “Article ID” that groups that person to an article. Base C is a list of suggested people that also has a number of fields but for example “Used Emails” could be a list of emails and “Affiliations” could be a list of potential affiliations. The goal is to have a comprehensive list of people tied to an article in Base B, and we are pulling from suggestions found in Base C. The way that a user proposes a person is through a softr form, which has some conditional questions as well as custom code I wrote for various checks (making sure the person being proposed isn’t already in the airtable, etc). To propose a suggested person, I have it set up such that a user clicks on a person from the suggested table, and will open into the details page for for that person with a form below to add that person to Base B.
I am trying to make it such that when the person goes to the detail page, the form already has in it’s input “Email” the data from “Used emails” and same for “Affiliations”. I can just make it hidden fields, because I need the user to choose which affiliation and which email to submit from the gathered information. My code so far is successfully pulling that information into the input field, but I am stuck trying to wrangle with the prebuilt softr code to be able to keep that prefilled information there, as my other code is continuously checking the user’s inputs validity. Does anyone have any suggestions on what to do? Whether it is helping with the code, or finding a better way?
Thanks in advance.