Page 1 of 1

Design Question

Posted: Wed Nov 06, 2019 5:52 pm
by gawr26
Hey guys,

I'm struggling implementing a design I have in mind.

It's a fairly simple App where we have three Tables: Applications, Criteria and Enablers.
The goal is to have an Application form where several Apps can be evaluated.

Let's say we want to evaluate a weather app. For this we have several Enablers e.g. a database, an api etc.
Every enabler should be evaluated towards criteria such as sustainability, power consumption etc.
Bildschirmfoto 2019-11-06 um 17.46.00.png
Now what I need to to is add each criteria next to the enabler and add a field for rating(1-10)
How can I list all entries of the criteria table next to every enabler?

Help is highly apprechiated!

Cheers

Re: Design Question

Posted: Wed Nov 06, 2019 9:27 pm
by Janusz
Maybe you can try to use Select object in which you can refer (using mysql) to any other table or you can just place data inside.
for example:

Code: Select all

SELECT cus_name,cus_name from customers
or

Code: Select all

A|A|B|B|C|C|D|D

Re: Design Question

Posted: Fri Nov 08, 2019 9:06 pm
by admin
gawr26,

Sorry but I don't understand the question.

Could you rephrase your question with a picture of what you want it to look like?

Steven