To check that it cannot be repeated, how should it be set?

AppSheet AppSheet Q&A
,
1

Ask the teacher
If you want to add data to the attachment, please use [DATE]+[AREA] + [[NAME]
To check that it cannot be repeated, how should it be set?
Thank you, teacher

2X_8_8338f97ad1939318d0e11f166d6d3e78c3f4f000.jpeg
2X_8_8338f97ad1939318d0e11f166d6d3e78c3f4f000.jpeg1024Ă—575 64.5 KB

2X_2_23825ef6e9d84df21fe64ca33e9449cb644d3b4b.jpeg
2X_2_23825ef6e9d84df21fe64ca33e9449cb644d3b4b.jpeg722Ă—705 47.2 KB

2X_d_dcf1e311de6a01d6a3596b6be5e0383aaf4e1885.jpeg
2X_d_dcf1e311de6a01d6a3596b6be5e0383aaf4e1885.jpeg737Ă—733 57 KB

2X_8_829fed5dd6120b14c5149a176348d869bb458a18.jpeg
2X_8_829fed5dd6120b14c5149a176348d869bb458a18.jpeg644Ă—530 42.6 KB

2

Answered here:

[Check that it cannot be repeated, how should it be set?](https://community.appsheet.com/t/check-that-it-cannot-be-repeated-how-should-it-be-set/24915/8) Questions

In the Valid If for the NAME column: ISBLANK( FILTER( “Participants”, AND( ([_THISROW].[DATE] = [DATE]), ([_THISROW].[AREA] = [AREA]), ([_THISROW].[NAME] = [NAME]) ) ) - LIST([_THISROW]) )

3

When selecting data in the NAME field …
Only the same data as the AREA field can appear!
Thank you

1 Like
4

Trouble teacher help
Thank you

5

Please clarify. Is there a problem? If so, please restate the problem you need help with.