Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Field that shows historical entry of another field

399 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi Airtable community :wave:

I am looking to create a field that updates based on the entry history of another a field. For example, imagine I had two fields “A” and “B”, and “A” is a multiple select field and “B” is the field that I would like to create. It would function like this:

  • Field A contains multiple select value “X” and if I change this to “Y” then I would like Field B to show “X”.

  • If I then change Field A from multiple select value “Y” to “Z”, I would then like Field B to show “Y”.

To provide some more context, I’m looking to solve this so that I can send a weekly update email that shows how a field changed during the period.

I’d really appreciate some help :slightly_smiling_face:

2 Replies 2

Hi,

Hope you are doing well !
I can help you out with this.

I have sent you a personal message, please check.

Thanks,

Nicole

pm sent, please check