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.
- Date is prefilled with the date => OK
- “Nom du client” is single line text
- “codepostal” is single line text
- “numéroduprédevis” is autonumber in the first table (table 1) and is link record in the second table (table 2) (the one with the form)
- adresse du chantier => is prefilled with text => OK
- typedetravauxtexte is a formula (transfering the answer of the bot (“1” “2” “3” or “4”) to text like “1”= “renovation” for example
- Same as above for typedelogementtexte (formula)
- Datededébut is a date format
- Délai is single line text
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