Skip to main content

Exclude a field from history


Forum|alt.badge.img

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

Justin_Barrett
Forum|alt.badge.img+20

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
Forum|alt.badge.img+12
  • Known Participant
  • 25 replies
  • June 30, 2023

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-shown/idi-p/30180

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

 


Reply