Jun 16, 2022 01:38 PM
When I run my Automation to Update a record it changes the membership Number.
In My row I have a unique membership number, But when sending the link to the member for updating when the form is returned the information is updated But it also changes the persons Membership number. How do I stop that
Jun 16, 2022 01:42 PM
Are members filling out an Airtable form? If so, filling out a form always creates a new record. A form cannot update an existing record by itself. It can be paired with an automation that finds the original record and updates the original record. Or you can use a third party portal service, although those have monthly fees.
Jun 17, 2022 12:41 AM
Thank you for getting back to me.
I am very new to Air Table, 17 days old, so lots of this is quite confusing to me, so any guidance and direction is Very Help full.
Jun 17, 2022 10:09 AM
Jun 17, 2022 10:35 AM
You have shared your base with creator privileges. You may want to remove the link so that you are not charged for anyone who clicks the link.
Your membership number is based on an autonumber, which has a new number for each record created. Because each form submission creates a new record, each new record has a new membership number. The original membership number for the original record is not being changed.
Jun 17, 2022 10:59 AM
I think I have also removed the link
Jun 18, 2022 06:48 AM
@kuovonne Thank you for explaining why this is happening, Is there away to up date the record without changing the membership number?
Jun 18, 2022 08:48 AM
The automation already is updating the info in the original record. You just have two records for the person. You cannot change the membership number in either record. If you no longer need the second record, you can delete it.
Jun 18, 2022 09:17 AM
@kuovonne Thank you. I am going to have to find an alternative way that it does not update the membership number
Thanks again for the help