Hello coda community!
I am completely struggling to get my subscription overview working.
The goal is that the i define with checkmarks who is using which service.
The second table calculates the me the cost per slot per service.
Afterwards everything should be sumed in the last column of the first table.
I tried with Lookup and Filter but so far without any good results.
Very grateful for valuable suggestions
Hi @Matthias_Amon ,
I’m not sure to understand the “per slot per service” but, is this what you were trying to do ? (or similar )
Instead of using checkboxes I added a Lookup fields (from the table
Subscription Prices to
Subscription Overview) and then selected for each person the services they are subscribed to …
To calculate the sum of those subscriptions, I just added this formula into the
And what it does is, it takes the list of services in the lookup fields, retrieve the corresponding
Monthly cost from the table
Subscription Prices for each listed services in a row and simply
Let me know if this helps (or if I’m completely wrong and it was not what you were after ) … or if you need me to add more info about what’s going on !
Hah, @Pch , you beat me to it.
My interpretation was summing, for each user, the price per slot rather than the price per subscription.
I’m actually really not sure if I interpreted the demand correctly … I just took a leap of faith … !
So, you might be right here
We can’t see you embed …
Have set to ‘anyone with the link can view’. Hopefully working now?
Thanks guys for your input!! Yes Tim you are right, i need an overview what each user has to pay me.
You nailed it
Really like this view.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.