I have two tables, “Appointment details” and “Hair Services”.
Hair Services has the following column:
I want to create an EnumList in the “Appointment details” table which adds multiple services from the “Hair Services” table. Also, I want to calculate the total time for each service and store it in a virtual column in the “Appointment details” table.
The appointment table should have the following.
Service list: (Enum list form Hair Service table)
Total time: (VC sums the estimated time for each service added)
Is there an app formula that I can use?
I see that part of this question has already been answered previously using SELECT and IN, but for some reason, I get an error (Parameter 2 in IN is wrong).
Any help is really appreciated. Thanks in advance.