填报报表 如何判断"数据库"中有重复的值就不提交
校验填报页面的数据是否重复- FineReport帮助文档 - 全面的报表使用教程和学习资料 (fanruan.com)
与数据库判断的话就,检验公式类似如下:
if(sql("数据连接名称","select count(*) as tn from mycode='"+a2+"'",1,)>0,false,true)
如果是联立多个单元格校验的话
and(len(GREPARRAY(split(A3,","),item=A2))<=1,len(GREPARRAY(split(B3,","),item=B2))<=1,len(GREPARRAY(split(C3,","),item=C2))<=1,len(GREPARRAY(split(D3,","),item=D2))<=1)