Image for post
Image for post
Image for post
Image for post
The concept behind the need to delete updated rows

What is it about?

The path we follow:

thisRow.[check 01] OR thisRow.[check 02] OR thisRow.[check 03]
DeleteRows(Filter(TT, Solution.Containsonly(false)))
Find(thisRow,thisTable)
Image for post
Image for post
our TT (ThisTable)

Check 01 — last updated row

Last Value
thisTable.Filter([Retour ID].Contains(thisRow.[Row ID])).[Row ID].FormulaMap(CurrentValue).Last()
Check 01
thisTable.Filter([last value] = thisRow.[Row ID]).IsNotBlank()

Check 02 — keep not updated rows

thisRow.[last value].Contains(thisRow.[Retour ID])

Check 03 — relate to deleted rows and keep the updated version

Step A
(thisTable.Filter([Retour ID].Contains([Row ID])).[Retour ID]).Contains(thisRow.[Retour ID]).Not() AND thisRow.[Retour ID] < thisRow.[Row ID]
Step B
thisTable.Filter([Step A]=true and [Retour ID] = thisRow.[Retour ID]).Last()
Check 03
thisRow.[Step B].Contains(thisRow)

The solution

thisRow.[check 01] OR thisRow.[check 02] OR thisRow.[check 03]
Image for post
Image for post
Image for post
Image for post
Coda.io and how to keep data aligned in a table

Written by

Huizer Automatisatie

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store