0

Issue with a button

Hi

 

I'd like to use a button to sort duplicates or no duplicates of names in a table.

So

I create a new field that I name "isDuplicate"

I create a button "isDuplicate" with the script :

 

let a := "" ;

for b in (select '🔺Feuille 1 OK-Tableau 1') order by 'Premier mot' do

if a = b. 'Premier mot' then

b.(isDuplicate := "Duplicate")

else

b.(isDuplicate := "Principal")

end ;

a := b.'Premier mot'

end

 

I get no error but when I click on the button nothing happens.

Could someone help le ?

Thank you

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    Well…

    Sorry, I forgot to create first a formula field "searching duplicates"

    Now I did it and I have some "duplicates" fields and some "empty" fields.Ok.

    But when I launch my button "isDuplicate" I only get one "Principal" display and all the other are "Duplicate"…

    Like
    • Ricardo Klünter
    • Customer Service Ninox
    • Ricardo_Klunter
    • 1 yr ago
    • Reported - view

    @Addinsell

     

    In case that your issue still remains unresolved, feel free to join our weekly Open office hour Webinar to ask your questions. You can find the webinars using this link:

     

    https://ninox.com/en/webinar

    Best regards,
    Ricardo

    Like
Like Follow
  • 1 yr agoLast active
  • 2Replies
  • 303Views