Hello guys,
Iโm trying to create a search form where I would see the expenses of different project in a specific time period selected. The search form is the following
I suppose that is a complex formula because it work between different Tables.
TKS to everyone who will Help me
If separate Two tables are created for each Project, then I am scared that it may not be suitable for AppSheet project as Joining table is not possible here, so far I know. It means if there is 10 Projects, so there will be 20 Tables and so on. In AppSheet there should have a parent child relationship between tables or all the data in one table. Either is suitable. I apologize, if I understand wrongly.
I know that i should use only one table TOTALE PROGETTO with all the Projectsโฆ I will do surly asap but for the next week I have to find a solution in a few time. I could use in the formula a LIST of partner IF the field project is a specific project like โprojectXโโ> IF([Progetto]=โprojectXโ, LIST(Parnter1, Partner2, Partner3, " "))
HI Daniele! Hope you are fine.
If you can re-organize the data following basic database rule, then your life would be very easy and your searching is achievable. Hope to listen from you soon.
At the moment, I have to use a short solution but I know that is non fully correct solution
I used this forumula IFS([PROGETTO]=โprojectxโ, LIST(โAโ, โBโ, โCโ),
[PROGETTO]=โprojectyโ,LIST(โAโ, โBโ, โCโ, โDโ),
[PROGETTO]=โprojectzโ, LIST(โAโ, โBโ, โDโ),
)
I hope to use the database rule asap but it require al lot of time because I have to change all setting that i have already done
Where you want to use this? In which field and event?
I used this formula in Auto Compute of column โPartnerโโ> Suggested Value
User | Count |
---|---|
42 | |
27 | |
25 | |
17 | |
13 |