I think the issue might be that you're giving the record "name", but not the record "ID", which is what the automation requires (multiple records can share the same name, which is why the ID is required). You should be able to click on the bubble for "Bill_Vorg_Nr" and a menu will pop up that allows you to select the record ID instead of record name.
Alternatively, I think you might be able to avoid having to use an automation and instead use a rollup field. If I'm understanding your setup, you have bills and payments. You're updating a "remainder" field with the automation. If this is correct, then in the table "Bills", you could add a rollup field of the linked record field of "Ratenzahlung", with function:
SUM(values)Then the field "Rest Bill Betrag" could be a formula field with the formula ("Ratenzahlung Rollup" being the field created in the previous step):
{Bill Betrag} - {Ratenzahlung Rollup}
I think the issue might be that you're giving the record "name", but not the record "ID", which is what the automation requires (multiple records can share the same name, which is why the ID is required). You should be able to click on the bubble for "Bill_Vorg_Nr" and a menu will pop up that allows you to select the record ID instead of record name.
Alternatively, I think you might be able to avoid having to use an automation and instead use a rollup field. If I'm understanding your setup, you have bills and payments. You're updating a "remainder" field with the automation. If this is correct, then in the table "Bills", you could add a rollup field of the linked record field of "Ratenzahlung", with function:
SUM(values)Then the field "Rest Bill Betrag" could be a formula field with the formula ("Ratenzahlung Rollup" being the field created in the previous step):
{Bill Betrag} - {Ratenzahlung Rollup}
Thank you for your answer 🙂
