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:
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.
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.
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.