0

notified to duplicate records

i have cerated a sample Table for our accounting.

the would like to be notified if there is a duplicate records being added.

I did achieve it to notify me if there is the same Billing Number twice.

 

et a := upper('RE-Nummer');

if cnt((select 'Rechnungseingangsbuch 2022')[upper('RE-Nummer') = a]) > 1 then

styled("Doppelt", "red")

end

 

that is not enough, I need it to notify me if the Billing number is Doppel but also if the amount is Doppel.

is it Possible?

Thx in Advance.

Ex.:

let a := Betrag;
let b := upper('RE-Nummer');
if cnt((select 'Rechnungseingangsbuch 2022')[Betrag = a]> 1  
    and if cnt((select 'Rechnungseingangsbuch 2022')[upper('RE-Nummer') = b]) > 1 
then styled("Doppelt", "red")
end

1 Antwort

null
    • mirko3
    • vor 1 Jahr
    • Gemeldet - anzeigen

    Do you need the script to display records that show duplicates of billing number and amount or billing number or amount?

Content aside

  • vor 1 JahrZuletzt aktiv
  • 1Antworten
  • 30Ansichten
  • 2 Folge bereits