Converting Airtable formula to Baserow

Technical Help
1 
IF({Action},
  SUBSTITUTE(
    CONCATENATE(
      Participants, " ",
      Premise, " ",
      {Actions (bold)},
      IF({Article}, " " & {Article}),
      IF({Adjective 1}, " " & LOWER({Adjective 1})),
      IF({Object 1}, " " & {Object 1 (bold)}),
      IF({Prep 1}, " " & {Prep 1}),
      IF({Adjective 2}, " " & LOWER({Adjective 2})),
      IF({Object 2}, " " & {Object 2 (bold)}),
      IF({Prep 2}, " " & {Prep 2}),
      IF({Adjective 3}, " " & LOWER({Adjective 3})),
      IF({Object 3}, " " & {Object 3 (bold)}),
      IF({Prep 3}, " " & {Prep 3}),
      IF({Adjective 4}, " " & LOWER({Adjective 4})),
      IF({Object 4}, " " & {Object 4 (bold)}),
      IF({Outro}, " " & {Outro}),
      IF({Mode}, " " & {Mode}),

      "."
    )
    , "," , " or"
    )
  )

Is this even possible to convert?

NOTE: Action can have multiple items

2

Hello @brunoafk, first of all, welcome to the Baserow community! :wave:

I’ve checked with our developer, @davide, and it seems that you can recreate a similar formula in Baserow, but there are some points to keep in mind:

  • The substitute function should be replaced with the replace function in Baserow. In your case, it should work out, but it’s also important to note that the replace function can’t specify the number of times you want to substitute strings, as it works with the substitute function in Airtable.
  • The concatenate function should be replaced with the concat function in Baserow.
  • It is not currently possible to reference and use the Collaborator field type in the Baserow formulas.
  • It’s not possible to make text bold; we don’t support functions like this one {Object 4 (bold)}.