Feb 06, 2023 01:50 PM
Okay, so it's 2023. Is it possible to update information in a record via a form and not delete data if the form field is left blank yet? I wish to allow users to update database information via a form, but I do not want the existing data in a field to be deleted if the user leaves a form field blank.
Is there a way to achieve this in the Airtable UI and not third-party apps?
Is it possible to add to the photos via this form submission instead of replacing all the photos with the update form? For example, photos 1, 2, and 3 already exist in the data. A user used the update form and uploads image 4. So it would update the data to have photos 1, 2, 3, and 4. As it is not, it replaces photos 1, 2, and 3 with just photo 4.
Thanks for reading!
Feb 06, 2023 04:55 PM
My workaround for this involves creating a form link with all of the current data prefilled, allowing the user to update the fields they need to while leaving the existing data there. Each of these submissions is linked to a single record in the "Data" table, and I use a rollup field with `MAX(values)` to identify the latest submission and display the data from it. This data is what's used for the form prefill as well
You wouldn't be able to display the currently attached files with this method I'm afraid, but with reference to your example of a user uploading image 4, if, in your data table, you added a lookup to the attachments field, you'd end up with a lookup field displaying photos 1, 2, 3 and 4
Feb 07, 2023 11:16 AM
Prefilling a form is impossible for me because my table is so massive and would exceed the 16,000 character limit. But, I think I found a workaround. A very tedious workaround, but it works.
As far as I can tell, you are allowed to create as many views as you want. This gave me an idea.
I started creating a form for each field. Each form only has one field on it. When the form is filled out, it only updates the one field that is in the form and leaves the other fields' data untouched! Yay!
Basically, if the field is NOT on the form, the update automation will leave that field alone. 🙂
The cons:
I have a few more ideas, but I do not see them working out. 😅