0

Search Button Script

Hi need a button script to search the Code on Search Code field text. 

6 replies

null
    • Mel_Charles
    • 4 mths ago
    • Reported - view

    do you mean like this?

    let xRef := 'Search Code';
    do as server
        select 'your tablename here' where Code like xRef
    end

      • Rafael Sanchis
      • Rafael_Sanchis
      • 4 mths ago
      • Reported - view

      Hi Mel

      Strange but it doesn't work.

    • Mel_Charles
    • 4 mths ago
    • Reported - view

    is "code" one of those choice fields?

    if so might need text if front of code like below

    let xRef := 'Search Code';
    do as server
        select 'your tablename here' where text(Code) like xRef
    end

      • Rafael Sanchis
      • Rafael_Sanchis
      • 4 mths ago
      • Reported - view

       

      The 'Code'is a text field in Activities Table (Not work)

      I place the Code in the Search Code (Text Firld) and in the button the Script.

       

      let xRef := 'Search Code';
do as server
    select Activities where text(Code) like xRef
end
    • Ninox partner
    • RoSoft_Steven.1
    • 4 mths ago
    • Reported - view

    With the code in a button, nothing will happen...

    You need to put this code in a view.

    You could also change the View-code to: 

    let xRef := 'Search Code';

    select Activities [ not xRef or text(Code) like xRef]

    You can remove the button then

      • Rafael Sanchis
      • Rafael_Sanchis
      • 4 mths ago
      • Reported - view

      OK 👍

Login to reply

Content aside

  • Status Answered
  • 4 mths agoLast active
  • 6Replies
  • 107Views
  • 3 Following