Help

Exclude a field from history

Topic Labels: Base design
682 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Alessio_Rossi
4 - Data Explorer
4 - Data Explorer

I need to know if is somehow possible not to include a specific field in the revision history.
I have a field which include tecnical data and it changes often, and this really distract when you try search something in the history…

2 Replies 2

Welcome to the community, @Alessio_Rossi! :grinning_face_with_big_eyes: I’m not aware of a way to exclude a field from the revision history. It might be worth it to reach out to Airtable support and see if there’s some undocumented way of doing this, though.

Calvin_Young2
6 - Interface Innovator
6 - Interface Innovator

For future readers...

When I've encountered this problem, I use the following workaround:

  1. Create a new table (or use an existing one--I usually have a table reserved for all kinds of hacky stuff like this)
  2. Link all the records from your initial table (Table A) to separate records in the new table (Table B)
    • You need to maintain a one-to-one mapping from records in Table A to records in Table B.  If you are constantly making new records in Table B, look up how to have an automation create the links for you
  3. Create a field in Table B with all the values from the field in question from Table A
  4. Switch the field in question from Table A to a lookup of the new field in Table B

You will have to edit the values in Table B, rather than in Table A--but that's the price you pay.  To be clear, this is a terrible workaround, but it seems to be the only way to avoid flooding the revision history.  There are a few feature requests which would provide a better user experience.  Give them an upvote!

https://community.airtable.com/t5/product-ideas/fr-show-revisions-to-specific-fields-only-or-tied-to...

https://community.airtable.com/t5/product-ideas/option-to-exclude-api-changes-from-revision-history/...