The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hi,
I need a formula that list (comma separated values) in a third field that exclude from a lookup field (in which there are comma separated dates) dates before the date in the first field.
Example:
Field1 “Join date” = 01 oct 2018.
Field2 “lessons”...
It is a wasting of time to select linked record in a field one by one.
For example if I want to pick attendance from a table of students I have to click ADD in the form and I can only select ONE linked record and then click again (!) ADD and select t...
TABLE “members”
Field Name
Field Date of Join (example: 01 oct 2018)
Field LOOKUP to TABLE “lessons” / field “Date of Lesson” (example: 15 sep 2018, 15 oct 2018, 15 nov 2018)* *: comma separated values lookup from table “lesson” below
TABLE “less...
And PLEASE let this multiselection filtered by another field (for example a Class).
Example:
Table1 “students”: field “name”, field “class”
Table2 “attendance”: field “date”, field “attendants” that is a link to table1 (“students”) that I can select ...