Image

GETRANDOMIMAGE

The GETRANDOMIMAGE function is a part of the image utility functions in the formula editor, used to generate a random image based on a description. It also allows you to specify an image format and the number of variations to choose from.

Syntax:

GETRANDOMIMAGE(description, [file type], [number of images])

description (required): The keyword or phrase describing the type of image you want.

file type (optional): The format of the image you want (e.g., "jpg", "png").

number of images (optional): The number of images to generate internally and then randomly select one from. This ensures you get a different image each time the page refreshes.

Example:

  1. Basic usage (only description)

GETRANDOMIMAGE("car")

This will return a random image of a car.


  1. Specify file type

GETRANDOMIMAGE("car", "png")

This will return a random car image in PNG format.


  1. Specify file type and number of images

GETRANDOMIMAGE("car", "png", "30")

This will generate 30 random car images in PNG format, and then choose 1 random image from that set. On each refresh, you will see a different image.

Last updated