0

Script for Search by Artist Name

Need a script for search by artist name, the screen is a Dashboard and take the  from Albums. On view Discography

8 replies

null
    • francescostefanello
    • 8 mths ago
    • Reported - view

    do you mean search the informations throug web sites? sorry i can not understand

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

      francesco.stefanellohi francesco no from web site from a table.

    • Ninox partner
    • RoSoft_Steven.1
    • 8 mths ago
    • Reported - view
    let s := 'Artists Name Search';
    if s then
        select Albums where 'Artist Name' like s
    else
        select Albums
    end

    You might also want a button to reset the search field : 'Artist Name Search' := null

    Oh, and the code above is for the view.

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

       Hi Steven

      There are any way to resolve this problem. Search for Creed and give me Creed and Creedence 

      • Ninox partner
      • RoSoft_Steven.1
      • 8 mths ago
      • Reported - view

      sure, you could use the exact search instead:

      let s := upper('Artists Name Search');
      if s then
          select Albums where upper('Artist Name') = s
      else
          select Albums
      end
      

      Here I use the upper() function to make everything uppercase (you can also use lower()) to avoid typos.

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

      Thanks again Steven works perfect.

      • Ninox partner
      • RoSoft_Steven.1
      • 8 mths ago
      • Reported - view

       you're welcome 👍

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

    Excellent 👍

Content aside

  • Status Answered
  • 8 mths agoLast active
  • 8Replies
  • 107Views
  • 4 Following