0

Syntax for "View" element

I am trying to use the "view" element to show some records

I use this formula and i only get the first record showing

let x := split('Herbs in formula', ",");
for i in range(0, count(x)) do
select 'KB-TCM herbs' where 'Pin Yin' = item(x, i)
end

Any ideas?

2 replies

null
    • Sean
    • 5 yrs ago
    • Reported - view

    It can be helpful to breakdown each action into its own formula field. I don't think the line

     

    let x := split('Herbs in formula', ",");

     

    has the result you are looking for. If you want an array that consists of values from a field in a table then you would use something like this...

     

    let x := (select YourTable).'Herbs in formula'

     

    Having said that, I'm not sure you'll need a for-loop. Can you describe what you want to do?

    • Ioannis
    • 5 yrs ago
    • Reported - view

    Hi Sean

    I found the solution

    It just needed a trim() command to clear the spaces 

    Now it works as a charm

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1308Views