Jun 01, 2022 09:35 AM
Good Day
I am very new to Airtable and loving it.
I am creating a data base from a csv file. Some of the information is missing, it’s a customer list with lots of personal information.
I would like to email it to the customer and get them to check the information and update it or correct it.
Please can you explain how I go about this?
Many thanks
Jun 01, 2022 09:56 AM
You can share a view with them to look at the data in read-only mode, but they won’t be able to edit the data unless you add them as a collaborator to the base:
Jun 01, 2022 10:11 AM
Will they view only their information or will they see everyone elses information
Jun 01, 2022 10:21 AM
Hi @Rodney_Beadon
With the shared view, they will only see what is visible in that view. So if you filter your view to only the records for one person and share that view with them, that is all they will see. If there are a lot of people you may end up making many views.
You can take another approach and send each person a custom link to a prefilled Form via automation that contains the current info and missing fields and lets them change or add information. This will create a new record for each form submission that you will then need to merge or an automation can take care of it for you.
Jun 01, 2022 10:57 AM
Thank you, I will find out online how to do this and try. Thanks for your help
Jun 01, 2022 10:59 AM
Let us know if you get hung up on anything. Happy to help.
Jun 02, 2022 02:57 AM
Thank you, I will see how far I manage and then ask for the help to fill the gaps I have been unable to.
Jun 02, 2022 08:21 AM
I have managed to create my form.
I am now trying to automate it so that when its submitted it updates the information.
I am struggling to do the following.
When the form is sent is it possible that it shows the current information on that persons details and then they can just update or add as needed?
I am trying to automate the reply so that it updates the existing information. I have gone to the automations.
For the trigger, i have put “When a form is submitted”
For the action, I have put “update record”
Configuration “Action will run always”
Table I have put my customer contact list
Record ID is where my first confusion comes in. There are drop down menus when I add the field it gives me 3 options “ID”, “Name” and colour. I am not sure which value I am supposed to choose
I then chose “Grid” and selected everything to be updated.
It now shows Render as HTML grid
In Fields when I click on choose field I have selected all the fields on the Base.
I then click on Generate a preview
I get the “fix testing error” message, the results show received invalid inputs
I can’t see where I have gone wrong.
Jun 02, 2022 09:23 AM
I think you are attempting to update the record that is the form response. The form will create a new record.
You will need the record ID of the record you want to update after the form is submitted. You can get a record id by making a formula field and putting in record_id(). Each row in Airtable has a unique record ID.
Your form URL needs to contain the recordID of the existing record as a hidden field. When the form is submitted, the new record will contain the ID of the old record. Then your automation will use that to match.
Jun 02, 2022 11:12 AM
Yes I suspect your 100% right the form once submitted goes into the last row of the base. So that would be fine for a new person entering there information for the first time. I am straight away seeing a problem as its not sorting alphabetically and its not allocating a new member number automatically.
I suspect I am trying to run before I can walk, as lots of your explanation is a very grey area only because of my lack of knowledge.
Time to do some more basic learning work
Jun 02, 2022 12:26 PM
I can try to help.
Here I have a table with a person that is missing a detail, in this case Age
I have added a few extra fields:
"https://airtable.com/shrsooN4LstLlseRy?" &
"prefill_First%20Name=" & ENCODE_URL_COMPONENT({First Name} & "") & "&" &
"prefill_Last%20Name=" & ENCODE_URL_COMPONENT({Last Name} & "") & "&" &
"prefill_Age=" & ENCODE_URL_COMPONENT({Age} & "") & "&" &
"prefill_recordIDMatch=" & ENCODE_URL_COMPONENT({recordID} & "") & "&" &"hide_recordIDMatch=true"
In the formula I am prefilling the form with the records I have and if I dont have it, it will just be blank for the person to add to the form. Importantly I am prefilling the recordIDMatch with the row’s ID.
Now I have a URL to send to each person (note: each row’s URL is unique to that person, so dont send it to the wrong person.
When the URL is opened in a browser, it will open the form, prefill with info I have and leave missing info blank. It will also add the recordID in the background, The user will not see this happen.
Now create your automation to update the record.
Trigger: when row is created
Action: Find Records where recordID is recordIDMatch
Action: Update Records we want to update the record found in step 1 and all other fields too.
This will let the person filling out the form correct any mistakes in the existing data too.
Jun 03, 2022 02:43 AM
Thank you I will go through this slowly so I understand. I will give you feed back later
Jun 05, 2022 06:33 AM
Hi
I have started working through this. on the Form URL I have put in the following formula. I actually copied and pasted yours as I am cluless still on writting and understanding the formulas.
“prefill_Surname%20Name=” & ENCODE_URL_COMPONENT({Surname} & “”) & “&” &
“prefill_DOB=” & ENCODE_URL_COMPONENT({DOB} & “”) & “&” &
“prefill_recordIDMatch=” & ENCODE_URL_COMPONENT({Record ID} & “”) & “&” &“hide_recordIDMatch=true”
I changed the fields to “Surname” and “DOB” I included the field Record ID as per the above instructions
I changed the form URL to the form I had earlier created. I suspect this is why i am having a problem.
I dont want that form sent from this link but the person getting the link to be able to click on the URL and be taken to their row for editing.
Not sure if I am on the right track or which URL to inclued
Many thanks
Rodney
Jun 06, 2022 01:35 PM
Hi @Rodney_Beadon
I think you are on the right track. Let me know if you are getting hung up on anything.
Jun 07, 2022 03:00 AM
Hi,
This is starting to make sense to me.
If the Base is already populated and some of the information is missing or just needs to be checked and up dated then, I would need to share the Base URL giving access to the relevant Row only. Is this correct so far.
If so how do I send that unique row to someone to check? I have given the row an ID but not sure how to share the row.
I have added this as a formula in a field called “Form URL” However when I try to save it it returns Invalid Formula.
CONCATENATE(https://airtable.com/app6DqS2bqGtz03sG/tblr4Zd7ZVWvs3DwV/viwKCe5b58hIV3glc/”,RECORD_ID())
Having less than limited experiance with formulas I am not sure what I am doing wrong.
I have been trying to follow the How to obtain record URL found at
https://support.airtable.com/hc/en-us/articles/360058897573-How-to-obtain-a-record-URL
Many thanks
Rod
Jun 07, 2022 04:45 PM
Hi @Rodney_Beadon,
For help with your form’s prefill URL, you may want to check out @kuovonne’s excellent Prefilled Forms app. I don’t think it supports hidden fields yet, but it should be a great reference tool for you:
Jun 08, 2022 05:14 AM
Thank you,
I am pulling my hair out. Mostly because I dont really understand the way to do the formulas
Jun 08, 2022 05:42 AM
If you want to use your formula above, you are missing the opening quotation mark around the URL.
Jun 08, 2022 08:21 AM
CONCATENATE”(https://airtable.com/app6DqS2bqGtz03sG/tblr4Zd7ZVWvs3DwV/viwKCe5b58hIV3glc/”,RECORD_ID())
I wanted to see if I could get this to work I, if I understood correctly put the opening quotation marks around the URL.
I still am getting the error message “Sorry, there was a problem saving this field. Invalid formula. Please check your formula text”
I thought my URL may be wrong so on the row I am wanting to create the unique URL for I, right clicked on the row, copy URL and was given this URL “Sign in - Airtable”
I have been trying to follow the example https://support.airtable.com/hc/en-us/articles/360058897573-How-to-obtain-a-record-URL
Also from the help from @Vivid-Squid I assumed that i needed to remove th “?blocks=hide” part of the URL, the reason when looking at examples I did not see it in any.
I then added the" /”,RECORD_ID())" but it is still not working.
In all honesty this is just guess work on my behalf and trial and error with no working result.
Possibly it would be better if I did a course on understanding the way a formula is constructed and laid out I would not be such a nusiance on the forum.
Any advice to learning and understanding the formulas will be greatly appreciated and possibly and explanation on why this formula is not working
Many thanks
Rodney
Jun 08, 2022 08:36 AM
Hi @Rodney_Beadon ,
It would be a good idea to read up on Airtable formulas, you can find documentation here: https://support.airtable.com/hc/en-us/articles/203255215-Formula-Field-Reference
Have you installed the Prefilled Forms app? It will write the formula for you.