Audit history + excel function

Hi, I’ve got two questions:

  1. Is it possible to retrieve grid history from the Audit? If it is possible, how can I do it for several records (bulk)?
  2. I would appreciate some basic Excel functions, which are probably possible here, but I guess one needs to code them. Anyway, is it possible to take a field and conditionally transform it? For instance, let’s say I have a column where are only three values possible (1, 2, and 3), and I want to transform every 1 into “you’re the number one”, every 2 into “you’re second”, every 3 into “I regret, but you’re that last on our list”. Could you help me, please?


1.Yes, you can get information from the Audit table using getData doo.table - Tabidoo Help Center.

  1. You can define such simple conditions in the Calculated field that are similar in Excel.

With Regards,