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

2 replies

null
    • Addinsell
    • 2 yrs 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"…

    • Customer Service Ninox
    • Ricardo_Klunter
    • 2 yrs 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

Content aside

  • 2 yrs agoLast active
  • 2Replies
  • 313Views