寻找 filemaker“列表”的参数帮助功能
我试图得到以下方程来返回结果，以逗号分隔在一行上。现在它省略了逗号并将每个结果放在单独的行上。我尝试过使用和不使用段落符号。
List (If ( ${1} = "备用" 且 panelSize ≥ 1 ; "1" ; "" ) ;
If ( ${2} = "备用" 且 panelSize ≥ 2 ; "2" ; "" ) ;
If ( ${3} = "备用" 且 panelSize ≥ 3 "" ) ;
${4} = "备用" 且 panelSize ≥ 4 ; "4" ; "" ) ;
If ( = "备用" 且 panelSize ≥ 5 "" ) ;
{6} = "备用" 且 panelSize ≥ 6 ; "6" ; "" ) ;
If ( $ 且 panelSize ≥ 7 ; "7" ; "" ) ;
If ( ${8} = "备用" 且 panelSize ≥ 8 ; "8" ; "" ) ;
If ( ${9} = "备用" 且 panelSize ≥ 9 ; "9" ; "" ) ;
If ( ${10} = "备用" 且 panelSize ≥ 10 ; "10" ; "" ) ;
If ( ${11} = "备用" 且 panelSize ≥ 11 ; "11" ; "" ) ;
If ( ${12} = "备用" 且 panelSize ≥ 12 ; "12" ; "" ) ;
If ( ${13} = "备用" 且 panelSize ≥ 13 ; "13" ; "" ) ;
If ( ${14} = "备用" 且 panelSize ≥ 14 ; "14" ; "" ) ;
( ${15} = "备用" 且 panelSize ≥ 15 ; "15" ; "" ) ;
If {16} = “备用”且 panelSize ≥ 16 ; "16" ; "" ) ;
${17} = "备用" 且 panelSize ≥ 17 ; "17" ; "" ) ;
If ( "备用" 且 panelSize ≥ 18 ; "" ) ;
If ( ${19} = "备用" 且 panelSize ≥ 19 ; “19”； “”）；
If ( ${20} = "备用" 且 panelSize ≥ 20 ; "20" ; "" ) ;
If ( ${21} = "备用" 且 panelSize ≥ 21 ; "21" ; "" ) ;
If ( ${22} = "备用" 且 panelSize ≥ 22 ; "22" ; "" ) ;
If ( ${23} = "备用" 且 panelSize ≥ 23 ; "23" ; "" ) ;
If ( ${24} = "备用" 且 panelSize ≥ 24 ; "24" ; "" ) ;
If ( ${25} = "备用" 且 panelSize ≥ 25 ; "25" ; "" ) ;
If ( ${26} = "备用" 且 panelSize ≥ 26 ; "26" ; "" ) ;
If ( ${27} = "备用" 且 panelSize ≥ 27 ; "27" ; "" ) ;
If ( ${28} = "备用" 且 panelSize ≥ 28 ; "28" ; "" ) ;
If ( ${29} = "备用" 且 panelSize ≥ 29 ; "29" ; "" ) ;
If ( ${30} = "备用" 且 panelSize ≥ 30 ; "30" ; "" ) ;
If ( ${31} = "备用" 且 panelSize ≥ 31 ; "31" ; "" ) ;
If ( ${32} = "备用" 且 panelSize ≥ 32 ; "32" ; "" ) ;
If ( ${33} = "备用" 且 panelSize ≥ 33 ; "33" ; "" ) ;
If ( ${34} = "备用" 且 panelSize ≥ 34 ; "34" ; "" ) ;
If ( ${35} = "备用" 且 panelSize ≥ 35 ; "35" ; "" ) ;
If ( ${36} = "备用" 且 panelSize ≥ 36 ; "36" ; "" ) ;
If ( ${37} = "备用" 且 panelSize ≥ 37 ; "37" ; "" ) ;
If ( ${38} = "备用" 且 panelSize ≥ 38 ; "38" ; "" ) ;
If ( ${39} = "备用" 且 panelSize ≥ 39 ; "39" ; "" ) ;
If ( ${40} = "备用" 且 panelSize ≥ 40 ; "40" ; "" ) ;
If ( ${41} = "备用" 且 panelSize ≥ 40 ; "41" ; "" ) ;
If ( ${42} = "备用" 且 panelSize ≥ 42 ; "42" ; "" ) ; ¶ ; ", " )
结果返回每个条目在其自己的行上，不带逗号。我尝试过使用和不使用 ¶。
I'm trying to get the following equation to return the results comma separated on a single line. Right now it leaves out the commas and puts each result on a separate line. I've tried with and without the paragraph symbol.
List (If ( ${1} = "Spare" and panelSize ≥ 1 ; "1" ; "" ) ;
If ( ${2} = "Spare" and panelSize ≥ 2 ; "2" ; "" ) ;
If ( ${3} = "Spare" and panelSize ≥ 3 ; "3" ; "" ) ;
If ( ${4} = "Spare" and panelSize ≥ 4 ; "4" ; "" ) ;
If ( ${5} = "Spare" and panelSize ≥ 5 ; "5" ; "" ) ;
If ( ${6} = "Spare" and panelSize ≥ 6 ; "6" ; "" ) ;
If ( ${7} = "Spare" and panelSize ≥ 7 ; "7" ; "" ) ;
If ( ${8} = "Spare" and panelSize ≥ 8 ; "8" ; "" ) ;
If ( ${9} = "Spare" and panelSize ≥ 9 ; "9" ; "" ) ;
If ( ${10} = "Spare" and panelSize ≥ 10 ; "10" ; "" ) ;
If ( ${11} = "Spare" and panelSize ≥ 11 ; "11" ; "" ) ;
If ( ${12} = "Spare" and panelSize ≥ 12 ; "12" ; "" ) ;
If ( ${13} = "Spare" and panelSize ≥ 13 ; "13" ; "" ) ;
If ( ${14} = "Spare" and panelSize ≥ 14 ; "14" ; "" ) ;
If ( ${15} = "Spare" and panelSize ≥ 15 ; "15" ; "" ) ;
If ( ${16} = "Spare" and panelSize ≥ 16 ; "16" ; "" ) ;
If ( ${17} = "Spare" and panelSize ≥ 17 ; "17" ; "" ) ;
If ( ${18} = "Spare" and panelSize ≥ 18 ; "18" ; "" ) ;
If ( ${19} = "Spare" and panelSize ≥ 19 ; "19" ; "" ) ;
If ( ${20} = "Spare" and panelSize ≥ 20 ; "20" ; "" ) ;
If ( ${21} = "Spare" and panelSize ≥ 21 ; "21" ; "" ) ;
If ( ${22} = "Spare" and panelSize ≥ 22 ; "22" ; "" ) ;
If ( ${23} = "Spare" and panelSize ≥ 23 ; "23" ; "" ) ;
If ( ${24} = "Spare" and panelSize ≥ 24 ; "24" ; "" ) ;
If ( ${25} = "Spare" and panelSize ≥ 25 ; "25" ; "" ) ;
If ( ${26} = "Spare" and panelSize ≥ 26 ; "26" ; "" ) ;
If ( ${27} = "Spare" and panelSize ≥ 27 ; "27" ; "" ) ;
If ( ${28} = "Spare" and panelSize ≥ 28 ; "28" ; "" ) ;
If ( ${29} = "Spare" and panelSize ≥ 29 ; "29" ; "" ) ;
If ( ${30} = "Spare" and panelSize ≥ 30 ; "30" ; "" ) ;
If ( ${31} = "Spare" and panelSize ≥ 31 ; "31" ; "" ) ;
If ( ${32} = "Spare" and panelSize ≥ 32 ; "32" ; "" ) ;
If ( ${33} = "Spare" and panelSize ≥ 33 ; "33" ; "" ) ;
If ( ${34} = "Spare" and panelSize ≥ 34 ; "34" ; "" ) ;
If ( ${35} = "Spare" and panelSize ≥ 35 ; "35" ; "" ) ;
If ( ${36} = "Spare" and panelSize ≥ 36 ; "36" ; "" ) ;
If ( ${37} = "Spare" and panelSize ≥ 37 ; "37" ; "" ) ;
If ( ${38} = "Spare" and panelSize ≥ 38 ; "38" ; "" ) ;
If ( ${39} = "Spare" and panelSize ≥ 39 ; "39" ; "" ) ;
If ( ${40} = "Spare" and panelSize ≥ 40 ; "40" ; "" ) ;
If ( ${41} = "Spare" and panelSize ≥ 40 ; "41" ; "" ) ;
If ( ${42} = "Spare" and panelSize ≥ 42 ; "42" ; "" ) ; ¶ ; ", " )
The result returns each entry on it's own line with no comma. I tried it with and without the ¶.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您的列表函数将它们全部放入列表中，并将 pilcrow ( ¶ ) 和“, ”也放入列表中。使用替代品的另一个建议很接近，但不完全是。将列表保留在那里，但在开头添加一个替补。
Substitute ( List ( allyourvalueshere ) ; ¶ ; ", " )
这将获取您的列表并将所有返回更改为逗号。
Your list function puts them all into a list, and also puts the pilcrow ( ¶ ) and the ", " in the list as well. The other suggestion to use Substitute was close but not quite. Leave the List there, but add a Substitute to the start.
Substitute ( List ( allyourvalueshere ) ; ¶ ; ", " )
This takes your list and changes all the returns to commas.
尝试在“列表”函数之前添加“替换”函数。
Try adding the "substitute" function before the "list" function.