Conditional Logic in Set Variable?

I’m trying to set a variable based on the result of a database read, to display contents if present and a nice ‘sorry nothing’ message if there were no matching records. This isn’t working, can it be fixed?

Thanks!

Try using this code:-{{if(23.Total number of bundles > 0;
'

  • ' & 23.Title & ' [' & 23.Review Quality & '] (' & 23.PubName-TXT & ') @ ' & 23.Time Posted & '
  • '; 'No New Yet!')}}
    1 Like

    Hello @The_FM_Co,
    You need to understand how the mapping syntax works with Make’s mapping dialog box.

    You need to use all the possible operators, keywords like if, >, () with that mapping dialog box.

    If you want to know more in depth then I recommend you to check this official Make course.

    Course material specific to this Topic.
    https://academy.make.com/courses/take/FoundationC01/multimedia/39529237-unit-6-introduction-to-mapping
    https://academy.make.com/courses/take/BasicsC03/multimedia/43977270-unit-1-introducing-functions
    Note: You need to sign up and complete the course steps to access specific material on the topic.