Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 27, 2021 10:29 AM
Hello all,
I am new on airtable but i did my homeworks before coming here to share my with the community…
I am trying to prefill a form in a table (table 2) with data from an other table (table 1 = “DATA table” which is filled with some data previously given via tchatbot conversation and functions which process some data into new results).
Here is my formula below (which is now in a formula column in my first table DATA where all my data is automaticaly collected from the tchatbot):
"PROPOSITION D'ENVOI D'APPEL D'OFFRE AUX ARTISANS DE LA TEAM URENOV &
“prefill_Date=” & ENCODE_URL_COMPONENT({Date} & “”) & “&” &
“prefill_N°%20de%20pr%C3%A9devis=” & ENCODE_URL_COMPONENT({N° de prédevis} & “”) & “&” &
“prefill_codepostal=” & ENCODE_URL_COMPONENT({codepostal} & “”) & “&” &“prefill_codepostal=” & ENCODE_URL_COMPONENT({codepostal} & “”) & “&” &
“prefill_Adresse%20du%20chantier=” & ENCODE_URL_COMPONENT(“A renseigner à votre convenance ici…”) & “&” &
“prefill_typedetravauxtexte=” & ENCODE_URL_COMPONENT({Typedetravauxtexte} & “”) & “&” &
“prefill_typedelogementtexte=” & ENCODE_URL_COMPONENT({Typedelogementtexte} & “”) & “&” &
“prefill_Dateded%C3%A9but=” & ENCODE_URL_COMPONENT({Datededébut} & “”) & “&” &
“prefill_D%C3%A9lai=” & ENCODE_URL_COMPONENT({Délai} & “”)
and i have a checkbox which i would like to prefill as “checked”
For the moment, only the Date and the text in “Adresseduchantier” are prefilled correctly.
Then I have a second form in a third table (table 3) which looks similar, so i put a second formula in table 1 (hope i can prefill multiple form from one DATA table?):
"APPEL D'OFFRE DE NOTRE CLIENT - IL VEUT VOUS RENCONTRER! &
“prefill_N°%20de%20pr%C3%A9devis=” & ENCODE_URL_COMPONENT({N° de prédevis} & “”) & “&” &
“prefill_codepostal=” & ENCODE_URL_COMPONENT({codepostal} & “”) & “&” &“prefill_codepostal=” & ENCODE_URL_COMPONENT({codepostal} & “”) & “&” &
“prefill_Adresse%20du%20chantier=” & ENCODE_URL_COMPONENT(“Elle vous sera communiquée ultérieurement”) & “&” &
“prefill_typedetravauxtexte=” & ENCODE_URL_COMPONENT({Typedetravauxtexte} & “”) & “&” &
“prefill_typedelogementtexte=” & ENCODE_URL_COMPONENT({Typedelogementtexte} & “”) & “&” &
“prefill_Dateded%C3%A9but=” & ENCODE_URL_COMPONENT({Datededébut} & “”) & “&” &
“prefill_D%C3%A9lai=” & ENCODE_URL_COMPONENT({Délai} & “”)
and i have a checkbox which i would like to prefill as “checked”
Hope this is clear enough. I thought my prefill formulas were right but seems like i missed something…
Thank you in advance for yours answers.
Best regards,
Anthony urenov
Feb 27, 2021 11:31 AM
Welcome to the Airtable community!
It looks like the forum is garbling the text of your formula.
Can you please try reposting your formula and enclose it between lines with triple backtics (`) like this:
```
Put your formula between triple backtics.
```
Can you include screen shots of both your source fields in the data table and the fields in your form table? Maybe there is something in the data, field types, or the field names that is causing the problems.
When you look at the url that the formula produces can you see the proper values in the url, even if the form isn’t prefilled correctly?
Feb 27, 2021 12:36 PM
Also, check out @kuovonne’s app, which lets you easily create prefill form links:
Feb 27, 2021 12:40 PM
I think that the original poster is already using the app.