Solved: General Form Query - Page 2

MauriceWhelan · 03-22-2019 02:28 PM

Hi. I have a form for capturing data for Timber Moisture Content and one of the fields is Date Ready for Treatment. If we take an example of 100 Bales of timber are checked for moisture, 20 are suitably dry so the user records the Date Ready for Treatment. Next week, of the remaining 80 bales that are checked a further 20 bales are ready. Is there a way I can record the date ready for treatment for the second 20 while maintaining the date ready for treatment for the first 20, all on the same record.

LeventK

@MauriceWhelan
In my sample app, [DATE_CHANGES] column is an ENUMLIST type with both Allow other values and AutoCompleteOtherValues properties are set to ON. Item separator is set to " , " (space comma space), Base type is Date. The below expression is in AppFormula:

=SPLIT(LOOKUP([_THISROW].[ID],"Record Changes","ID","CHANGED_DATES"))+
IFS(NOT(IN([DATE_FOR_TREATMENT],SPLIT(LOOKUP([_THISROW].[ID],"Record Changes","ID","CHANGED_DATES")))),
LIST([DATE_FOR_TREATMENT]))

View solution in original post