hy guys,
i want to ask for my problem
i build data like this (in table project)
and this my view
i use this formula, but its not work
if (
ANY(SELECT(project[unit], (ISNOTBLANK("project[idproject]"))))
<=
COUNT( SELECT( QR CODE[keterangan], ([idproject] = [idproject]))),
ADDS_ONLY,
READ_ONLY
)
can you help me?
Meaning you want to prevent duplicate data? Or you want each user to be able to add only one row ever?
i want to when user add data in table qrcode
data to add following ref table from unit in project
when count data in qr code is full data can’t add
User | Count |
---|---|
16 | |
10 | |
10 | |
8 | |
3 |