I have a reference table in this app to enter daily attendance information.
What expression should be written for โShow _ifโ in the main attendance related virtual field in the main form?
There are a couple of approaches you may use.
ISBLANK(
FILTER(
โAttendanceโ,
(AND([_THIS] = [Attendance ID], [Name with Initial]=[_THISROW].[Name with Initial]))
)
- LIST([_THISROW])
)
Here โAttendanceโ is name of the Attendance table. Please change suitably.
This will prevent more than one child record being created for the same day per person. However, it will NOT hide the โNewโ button after adding one record in the attendance table.
Please take a look at the last part of the article below on duplicates prevention approach.
Edit: Please refer posts below
https://community.appsheet.com/search?q=disable%20child%20add%20button
Edit: Some edit to expression to make it person specific.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |