Hello Richard and thanks for the note.
Given that I would like to allow members to display, check and update their stored information on a regular basis, I ended up going off piste and wrote a little script which I think might suit.
The procedure is that every now and again a CSV file is exported which contains all 'user updateable' fields.
That file is uploaded to a website.
A script then reads the uploaded file and displays a member's information in an update screen.
The member is invited to check the contents and make any required changes.
Once the changes have been made, the 'Tell Us' button is used to email any updated fields to the Secretary who will then apply them to the AirTable file manually.
Not very polished and still being worked on but should do the job. I am not too concerned with the manual input aspect - even if the member updated the Airtable file directly, the Secretary would still need to inspect the records subsequently to ensure that no duff information had been entered.
Have a look at
It is all test data so feel free to so whatever you want.
I also need to check that using the Record ID from Airtable is secure enough for the purpose.
Regards
John Tuach
