Well I tried the bulk action scheme to no avail.
Now I’m trying the enumlist approach. I made an intermediate ‘form’ table which has two columns referenced to another sheet. Namely supplier name, and bill number.
The supplier name column is an enum type with base type ‘reference’, and the bill number is enumlist ( since I have to choose multiple) type with base type ‘reference’.
Now I don’t know why yellow triangles have popped up in both of those columns (a bit of research showed that it has something to do with broken references, but I couldn’t find anything pertinent), and besides that I have written an expression for the amount column (that will sum the values of the bills whose number I choose here) :
sum(select(User bill submissions[Bill Value], in([Bill Number] , User bill submissions[Bill Number])))
Now I don’t know why the “amount” field comes pre-filled with a value, greyed out, and me being able to do nothing about it. Does this have something to do with the ‘broken reference’ thing?