I use an automatic translation function, so some sentences may be incorrect, but we appreciate your understanding.
I am currently creating an Appsheet for business management.
I would like to create a work completion report based on the reservation details.
Refer to the reservation table and display in the initial value of the work completion table.
When changing ① ID work details in the work completion table,
I want to update ① work details, ① unit price, and ① amount.
What is the correct formula to enter as the initial value?
If the question itself is incorrect, please let me know other solutions.
I set up the table and columns as follows.
① ID work content, ① work content, ① unit price, ① amount exist from ① to ⑦.
●table: reservation
・Column list
[ID reservation]
[① ID work details] / Ref
[① Work details] / Text/Initial Value: [ID work reservation]. [① ID work details]
[①Unit price] / number/Initial Value: [ID work reservation].[①Unit price]
[①Amount] / number/Formula: [①Quantity]*[①Unit price]
●table: work completed
・Column list
ID reservation/Ref
[① ID work details] Ref
[① Work details] Text / Initial Value: [ID work reservation]. [① ID work details]
[①Unit price] number / Initial Value: [ID work reservation].[①Unit price]
[①Amount] number / Formula: [①Quantity]*[①Unit price]