单元格获取参数的显示值并关联字符串形成标题?
用value函数试过了,不能适配参数控件是多选的情况,多选的话返回空;
请问怎么解决多选的情况?
=ds1.select(name,code=$cs)+"固定字符串"
=sql("FRDemo","select name from table where code='"+REPLACE(code,",","','")+"'",1,1)++"固定字符串"
直接这个公式
JOINARRAY(MAPARRAY(split(单元格,','),MAP(item,"ds1","字段id","字段名称")),',')