03-30-2023 12:22 AM - edited 04-14-2023 12:11 AM
This post is part of the SAP Build Community Challenge (April 2023)
This week’s challenge involves formulas – a key feature of SAP Build Apps. Formulas are used in bindings of components, and enable you to manipulate data before it is displayed in a component or before it is sent to a data source.
Formulas are created in the formula editor, which provides some tools for making writing formulas easier:
Here are some learning materials about formulas:
We will give you an app that looks like this (I like cats).
To set up the challenge, do the following:
You should now have the skeleton project.
Inside the app, we have already created a page variable called StartValue that contains the starting data that we want you to transform.
When you are ready, on the UI Canvas, select the Transform button, open the logic canvas, then select the Set page variable flow function, and finally go to set the formula for Assigned Value on the right (which currently returns an empty list).
This is what you need to do:
Your screenshot should look something like this but without the blur (I need to see the names and averages) and with your name:
Good luck ... and have fun!!
You have to do 3 things in the formula (aggregate/group, sort, round), so find a function that does each one. Use the wonderful editor features that document the available functions.
For example, for aggregating, go to the List area, and then find a function that aggregates (in this case, GROUP). You'll see all the documentation for it on the right, plus a little playground inside the documentation for testing it. Pretty cool!
03-31-2023 4:16 AM
Thanks! Look forward to giving this interesting challenge a try!
04-13-2023 11:36 AM
Where can I learn! Are there any trainings?
04-13-2023 9:12 PM
Did you try out the challenge first?
And internally at SAP there are additional resources, if you contact me offline
03-31-2023 5:50 AM - edited 03-31-2023 3:35 PM
First answer from me 🙂
03-31-2023 6:12 AM
03-31-2023 6:54 AM
thank you for a great challenge.
04-03-2023 12:23 AM
Movie is Madagascar - of course
04-03-2023 12:29 AM
04-03-2023 12:31 AM
Yes - we worked together with Patrik (he is my Padawan) on the solution above 🙂
Btw great Idea these dev challenges - really funny way how to learn - not just - problem solving, algorithmic thinking and as a bonus - deep dive to the tool (Appgyver) itself and documentation as well.
04-03-2023 1:13 AM
04-03-2023 2:48 AM
04-03-2023 3:24 AM
He does that on friday, but posted picture only on teams (and without name). Now he has day off - so just like that:
And screenshot of our team as a proof 🙂
04-03-2023 4:18 AM
I have overlooked this requirement on Friday. Formula updated on Friday evening as mentioned by my colleague Vlado 🙂
Have a great day.
03-31-2023 7:58 AM
Thanks for this challenge, tricky and interesting 🙂. Please see the screenshot below:
03-31-2023 9:12 AM
03-31-2023 9:37 AM
03-31-2023 1:49 PM
Completed the challenge but don't know what movie they are from 🙃
04-02-2023 5:10 AM - edited 04-02-2023 5:12 AM
Looking forwards to the next challenge!!
04-03-2023 2:29 AM - edited 04-03-2023 2:34 AM
Hi, Here is my screenshot.
04-03-2023 2:46 AM
04-03-2023 2:55 AM - edited 04-03-2023 2:57 AM
Movie is Madagascar
Added my name now
04-03-2023 4:30 AM - edited 04-03-2023 4:32 AM
04-03-2023 5:31 AM
04-03-2023 7:19 AM
04-03-2023 7:34 AM
04-03-2023 8:35 AM
Hi, below my screenshot.
04-03-2023 1:06 PM
Thanks for the challenge.
04-03-2023 1:50 PM
My week 1 submission. The formula was a bit challenging for the first week.
04-03-2023 10:53 PM
04-04-2023 1:21 AM
Finally managed the formula using the hints you have given. Thanks for this interesting learning challenge.
04-04-2023 1:30 AM
04-04-2023 1:59 AM
one of my favorite movies.
04-04-2023 2:29 AM
04-04-2023 3:44 AM
I would say the 2nd one. Which one is your favorite
04-04-2023 7:02 AM
04-04-2023 3:55 AM
04-04-2023 6:55 AM
04-04-2023 5:50 AM
Hi Dan, nice challenge!
The movie is Madagascar 🤣
04-04-2023 6:16 AM - edited 04-07-2023 2:30 AM
Thank you for this challenge!
Movie Name: Madagascar