Hi,
I’m working on something for my employees, they are musicians and I need them to check in when they arrive to rehearsals and they have a show. Since rehearsals and shows have different earnings, i managed to show the column of rehearsal price when they click on rehearsal, and when they click “show” the show price column is shown. Visually it works fine, the only problem is that when they check in either option they click “rehearsal” or “show” both values are saved in my data sheet and it’s a problem for me cause then I cannot automate the final calculations since each entry results as a rehearsal and show price. I must say that they don’t write the price in the form, it’s dereferenced from another table, so when they select the show in the form it automatically populates the price.
Any help? thank you