Feb 28, 2024 08:31 AM
I am facing difficulty in prefilling forms with 'Link to another record data type'
Data is occasionally getting printed when the data type is 'Link to another record' with 'Allow linking to multiple records' switched 'ON'
What changes should I make so that it works well?
Feb 28, 2024 04:51 PM - edited Oct 03, 2024 01:47 PM
I can't remember the bug specifically, but there is some sort of a bug in Airtable that prevents the prefilling of linked records.
If I remember correctly, if you have certain rules set on your linked record field (in the right margin of the interface form editing screen), then you are no longer able to prefill the form through the URL.
So try removing all the rules in the right margin, and see if that fixes the problem.
If you figure it out, be sure to email support@airtable.com to report it.
Alternatively, you can update records through a form — without needing to specify any prefill values at all — by using Fillout's advanced forms for Airtable.
Fillout is now my favorite way of prefilling forms (and also updating records) in Airtable. It is 100% free, and it offers all sorts of features that Airtable's native forms don't offer!
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Feb 28, 2024 06:19 PM - edited Feb 28, 2024 06:19 PM
Ah, that's because the linked field has a space between each linked record name, so the resulting encode isn't in the right format. You're going to need to add a rollup field to display the primary field of the linked table, and use the formula "ARRAYJOIN(values, ',')" (thus removing the space), and then use that rollup in your ENCODE_URL_COMPONENT, and that'll work fine
Feb 29, 2024 07:26 AM
You're absolutely right about the inconsistent behavior of this formula. I initially tried writing my own formula for the currency field without success. While @kuovonne's extension (which you have suggested in other posts) worked well for currency, it hasn't resolved the 'Link to another record' issue. I'm not sure if this is due to my addition of the RECORD_ID or another underlying cause. I'll follow your guidance and reach out to Airtable support for further clarification.
CONCATENATE(
"&prefill_ocdr=",
RECORD_ID(),
"&hide_ocdr=true"
)
Thank you @ScottWorld.
@ScottWorld wrote:I can't remember the bug specifically, but there is some sort of a bug in Airtable that prevents the prefilling of linked records.
If I remember correctly, if you have certain rules set on your linked record field (in the right margin of the interface form editing screen), then you are no longer able to prefill the form through the URL.
So try removing all the rules in the right margin, and see if that fixes the problem.
If you figure it out, be sure to email support@airtable.com to report it.
Alternatively, you can update records through a form — without needing to specify any prefill values at all — by using Fillout's advanced forms for Airtable.
Feb 29, 2024 07:30 AM - edited Oct 23, 2024 03:36 AM
Hi @mshah72,
Your formula looks perfect, so it should be working perfectly.
And using the Record ID is actually the preferred way to do it.
Did you check to see if you had any rules/filters in the right margin to make sure that those are not interfering with your prefill?
In the meantime, you can set this up in about 3 minutes with Fillout’s advanced forms for Airtable, so that would probably be the best path to go down to quickly solve this issue.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Feb 29, 2024 09:44 AM
Screen captures that show the entire formula, the formula result, and the result when clicking on the link for the prefilled form would be useful.
Mar 04, 2024 10:28 AM
@ScottWorld I have removed all the rules/filters
@kuovonne here are the screen captures -
crse_name and RecordID are not getting prefilled in this.
Mar 04, 2024 04:40 PM
The new form now saves your input until submit is complete.
Try the Clear form at the bottom left once.
Oct 23, 2024 12:02 AM
Hello, @ScottWorld
I urgently need some help. I’m trying to use the pre-fill feature to prepopulate 650 names and details for smooth registration. I’ve successfully generated the pre-fill formulas (i.e., URL links) for each name and detail, but I’m now stuck on how to combine everything into a single URL link. I need one link to access all the pre-filled names, instead of handling each one individually. Could you please assist me with this?. Thank you
Oct 23, 2024 03:41 AM - edited Oct 23, 2024 03:41 AM
That is not possible with prefilling. Each record gets its own unique link. As I mentioned above, I would only recommend using Fillout’s advanced forms for Airtable for this, which will give you a short & unchanging URL for each record.
If you need to see all your records simultaneously on one screen, then just use Airtable’s data layer or Airtable’s interfaces.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld