currently I build a little sales doc for a test shop. There I have two tables:
No. 1 contains the current pricing. It does not have any history, just the current pricing.
No. 2 contains the sales of the day.
Via a button I want to put the current pricing from table 1 into table (for today only to not overwrite historical data).
I tried two formulas:
No. 1: With a date picker
No. 2: With “Today” formula:
In both cases the button is clickable, but I receive an “unexpected error”:
Does someone know, what I am doing wrongly?
Thank you and best regards,