Skip to Content

🟣 Devtoberfest 2024 - SAP Build Apps Formula Editor Challenge

Beginner
30 min.
Cloud, Beginner, Tutorial
You will learn
  • A lot about technology – and yourself – during Devtoberfest
neelamegamsShrinivasan NeelamegamOctober 24, 2024
Created by
neelamegams
September 19, 2024
Contributors
thecodester
neelamegams

Prerequisites

  • None

For all the 5 questions below, you will write a formula that works in the SAP Build Apps formula editor. Please see this help link on how to invoke the Formula Editor in SAP Build Apps and some sample functions provided. In the Build Apps tool, you will be able to see all the Formula functions available.

This challenge is part of the Devtoberfest 2024, a celebration of and for Developers. For more information and to join the fun, see the Devtoberfest Group and join the group.

Devtoberfest

 

For specifics on the Devtoberfest contest and the grand prize, see this Devtoberfest 2024 Contest blog

  • Step 1

    Find the missing function that can convert “ICETEA” to 1C3734.

    UPPERCASE(________(“ICETEA”))

    Question 1

  • Step 2

    Consider an app variable called sentence that contains many words in it, separated by a space. Write the missing function in the formula below in order to display the output as a string with the words in reverse order and separated by a comma without spaces.

    JOIN(________(SPLIT(appVars.sentence, “ ”)), “,”)

    For example, if the sentence is “a very long sentence”, the output should be “sentence,long,very,a”.

    Question 2

  • Step 3

    Enter the function to complete the formula so that it fills the button background color with #0070f2 if the number on the button is Odd and fills the button background color with #E1F4FF if the number is even.

    IF(________(repeated.current.id), “#0070f2”, “#E1F4FF”)

    The formula should be generic enough to display the background color accordingly, irrespective of the position of the odd number. For example, in the following image, only the numbers 1 and 3 have the background color as #0070f2 since they are the only odd numbers.

    Button Odd Color

    Question 3

  • Step 4

    Complete the formula to print today’s date in the format, for example, 30/09/24 format.

    ______(“DD/MM/YY”)

    Question 4

  • Step 5

    Find the missing function in the formula below to convert (“foo”, 8, “ABC”) to “ABCABfoo”.

    __________(“foo”, 8, “ABC”)

    Question 5

Back to Top
Back to top