Jul 15, 2022 07:05 AM
Having a bit of trouble and would love some insight.
I have 2 tables. The first table is a Work Order Table and the second is an Activity log table. In Table 1 I have a button configured to upon click open the form view on Table 2. I have a referenced field in Table 2 to reference the record the button was clicked on table 1.
I am struggling with the button url on a table 1 record that will open the form on table 2 and prefill the referenced linked fields.
Here is what I have so far:
Jul 15, 2022 08:22 AM
Welcome to the community, @JaredKinchen!
I would recommend using @kuovonne’s Prefilled Forms extension. It doesn’t support hidden fields in forms, but as long as you don’t need hidden fields, it should work well for you:
Jul 15, 2022 08:59 AM
I have already tried his extension and the URL isn’t populating the results for the linked records.
Jul 15, 2022 09:02 AM
Again, I am using a button in one table to open up and populate the form view of another table. So the linked fields in the second table need to be prefilled with the related data in the first table. I am not sending the form to someone with pre-filled information in the form from the table that the form is in.
Jul 15, 2022 09:08 AM
@ScottWorld just tried that extension again. It gave me the same formula I am using. Still not working. So not sure which part is not right.
Jul 15, 2022 11:42 AM
Prefilling a form with linked records works fine for me. I would check the spelling of your field names and make sure you’re putting in a valid primary field value for the prefill value.
Jul 15, 2022 12:08 PM
You can prefill a linked record with either a primary field value, or with Airtable’s internal record ID.
If you are prefilling with a primary field value, keep in mind the following:
When possible, I recommend prefilling linked records using Airtable’s internal record IDs. I find it is much more reliable.
Jul 20, 2022 09:38 AM
Thank you, I did get it working, and yes, I do prefer to do all of this airtable without the use of forms. My issue is that when I have a linked record field and go through the process to add a record from that linked field, it goes to the default view (I think its the first view listed) of the table for that linked record, regardless of the view I assigned it to look at.
This is problematic and not sure why if I assign the linked field a view to look at why the new record being created won’t look at that view.