Generating multiple PDFs

AppSheet AppSheet Q&A
1

Hi Everyone,

I am exploring more on appsheet and generation of files through automations. Currently I am trying to find a way to generate multiple PDFs (certificates) for each of the participant of a training.

I am hoping to trigger this by just clicking an action button which updates a column then call out each item on the attendees list to have their own certificate pdf. However the foreachrow option is only available on the scheduled automation option.

Any suggestions that may help would be really appreciated. Thanks in advance!

2 Likes
2

Yes, I believe it is possible to generate a PDF for each participant:

:one: Create a “trainingss” table to store course information.

:two: Create a child table “Participants”, related to “Capacitaciones”, where participant records will be stored.

  • Ensure the reference column linking “Participantes” to “Capacitaciones” has “Is a part of” enabled.

:three: Create an inline action in “trainings” that triggers an action in “Participantes” using “Execute an action on a set of rows”. Put a pdf icon, printer, sheet or whatever you want.

  • This action should invoke another action in the child table called “updateRow”.

:four: Define the “updateRow” action in “Participants” as “Set the values of some column in this row”.

  • Use a column (e.g., [Update]) and set the expression to:

    [Update] + 1

  • This ensures a change occurs in the row, which can then trigger automation.

:five: Configure an automation that triggers when a row in “Participantes” is updated.

  • Use the task “Create a new file” to generate a PDF containing participant details.

:six: Expected Behavior

  • Every time a row in “Participantes” is updated, a corresponding PDF will be generated.
  • If you have 100 participants, 100 PDFs will be created.
  • Be patient, as generating multiple PDFs can take some time.

:white_check_mark: This setup ensures an automated, scalable solution for generating participant certificates or reports!

Atte Gustavo

2 Likes
3

Keep in mind another point, you should consider that if you press that button by mistake, pdfs will be generated. Configure the action with confirmation and, if you want to avoid duplicate generation, add a Y/N field to prevent records whose value is true from creating pdfs.

2 Likes