How to create a flow chart?

10

you can use the mermaid server directly to render the whole string

  • save the whole diagram string in a variable, lets call it DIAGRAM
  • save the URL of the mermaid server in URL, see below
  • render the diagram using the Embed() formula

the URL to use is

https://mermaid.ink/svg/

the Embed() formula to use is

Embed(
    URL.Concatenate(
        EncodeAsBase64(
            DIAGRAM
        ),
        WIDTH, HEIGHT,
        force: True
)

Where WIDTH & HEIGHT are the size of the diagram you need.

Use this on the canvas or in a column formula.

If you want, you can use semicolon chars instead of Newline chars in the DIAGRAM source.

The EncodeAsBase64() function converts your DIAGRAM text into a character string that is safe to use inside a URL call to the server.

Max

3 Likes