Help

Prefilling Form URL with hyphenated data

Topic Labels: Formulas
Solved
Jump to Solution
1240 2
cancel
Showing results for 
Search instead for 
Did you mean: 
nisha_elliott
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi! I’m trying to create a prefilled form URL, but I believe the prefill isn’t working because I’m trying to prefill information with hyphens. Any ideas on how I can make this work?

Example:
Field Name: Type Name
Example data: Apples - Michigan

Form URL: “https://airtable.com/shrxxxxxxxx?"&“prefill_”&ENCODE_URL_COMPONENT(“Type Name”)&”="&ENCODE_URL_COMPONENT({Type Name})

How do I make sure “Apples - Michigan” doesn’t break the URL (and in turn, not prefill the form)?

1 Solution

Accepted Solutions
nisha_elliott
5 - Automation Enthusiast
5 - Automation Enthusiast

AH we found another error in our formula, apologies! We thought the hyphen just wasn’t translating well into the URL but turns out it was something else!!

See Solution in Thread

2 Replies 2
Raminder_Singh
7 - App Architect
7 - App Architect

Hi @nisha_elliott your formula should work.

ENCODE_URL_COMPONENT does exactly that. What URL is generated currently?

nisha_elliott
5 - Automation Enthusiast
5 - Automation Enthusiast

AH we found another error in our formula, apologies! We thought the hyphen just wasn’t translating well into the URL but turns out it was something else!!