I am struggling to automate updating a Jotform column by 1

[Button007]

I have set up an art class enrolment and attendance system using Jotform. The Enrolment Form works well to collect the student’s name, email, number of classes option, and payment. After enrolling, each student receives an automatic thank you email that includes a personal QR Code. They will bring that Code with them for me to scan at each class and record that they’ve attended. The code works to open the Attendance Jotform and prefill their name so it will always match the Enrolment Form. The intention was that each time I scanned their code it would add 1 to the Total Attended Column and update a Classes Remaining column that subtracts that number from the number of classes bought. Unfortunately, Jotform does not have a running total operation available. It seems like I should be able to do this in Make but I think I can’t see the trees for the forest at this point.

I would be incredibly grateful for any ideas.

[Stoyan_Vatov]

Hey there,

where are you trying to store this info at the moment? Is it in a specific field in the form? Do you mind sharing some more technical info?

[Button007]

Hi,

I only have 2 jotforms and need to keep a running total of how many classes each student attends so I know when they need to pay for more. There is a hidden field in the Enrolment Form so that the corresponding column on the Table can be used in conjunction with a formula column to calculate ‘classes remaining’.

I have built a scenario with 3 Jotform Modules in Make. The first one is the trigger when anyone submits the attendance form. Module 2 is a GET form submissions to retrieve all enrolment form submissions which is effectively the class roster. Between MOdule 2 and Module 3 there is a filter to find if {lastName} in Attendance form is contained in {lastName} in Enrolment form to find the student’s record. Module 3 is meant to simply add 1 to the value in the total attended column of that student. All the test runs work until Module 3 when I get an address error.

getaddrinfo ENOTFOUND eu-api.jotform.comhttps

[Stoyan_Vatov]

Not that its not possible to do it your way, but have you considered using a separate data base to keep track of enrollment? It will be much easier this way, than digging through form submissions to see who is enrolled in which classes.

You can start with Make Data Stores and see if you can implement something there, that is if you don’t want to invest in a separate platform.

[Button007]

Ha! I am happy with all suggestions. The idea was to automate as much of the process as is possible. I have only 1 class a week and about 12 students. The forms are live and work well for enrolment and creating the roster so it’s no work for me now. The QR Code is easy to scan with my phone as I circulate the room to teach while they darw. The scan opens the attendance form, prefills the name, and can enter a value of one if necessary or just submit the name to trigger the scenario. If I could figure out how to make that update the value of classes attended, I can then set up an automatic email when the classes remaining reaches 1 so students could buy more classes and I didn’t need to keep track every week to give them warning.

[Button007]

Also, I only have one class.

[samliew]

Welcome to the Make community!

To allow others to assist you with your scenario, please provide the following:

1. Relevant Screenshots

Could you please share screenshots of your scenario? Also include screenshots of any error messages, module configuration fields, and any filter settings. We need to see what you’re working with to give you the best advice.

You can upload images here using the Upload icon in the text editor:

2. Scenario Blueprint

Please export the scenario blueprint. Providing your scenario blueprint file will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return - this would greatly benefit you in implementing our suggestions as you can simply paste module exports back into your scenario editor!

To export your scenario blueprint, click the three dots at the bottom of the editor then choose ‘Export Blueprint’.

You can upload the file here by clicking on this button:

3. Output Bundles of Modules

Please provide the output bundles of each of the relevant modules by running the scenario (you can also get this without re-running your scenario from the History tab).

Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

• Method 1: Type code block manually

  Add three backticks ``` before and after the content/bundle, like this:

  ```
  <sup>content goes here</sup>
  ```

• Method 2. Highlight and click the format button in the editor

  

Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved.

Sharing these details will make it easier for others to assist you.

[Button007]

[Button007]

It’s such a small scenario and is very nearly doing what I need.

I’m sure someone more experienced will know just what I’m missing and I’ve gone round and round so often I’m not sure what I’ve already tried.

[samliew]

Did you mean to use PUT instead of PATCH?

According to the official Jotform API documentation, there is NO “Patch” method.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[Button007]

blueprint.json (19.3 KB)

Here is the blueprint. Sorry Sam I just saw yor note about Jotform. I will try PUT. I just need to increase the existing value of a field by 1.

[samliew]

Looks like you want to use the endpoint

POST /submission/{id}

instead.

For more information, see Jotform API

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[Button007]

OK, will try that. Thank you.

[Button007]

Now it won’t even run the trigger module. Says unprocessed data in the webhook?!

[Button007]

I ran it with the ‘use existing data’ option and it failed at the POST module.

I am not quite sure how the modules work and if I need to reference the {12.id} from the GET module or not since the POST module is really only addressing the one filtered out result? The filter works and identifies the Bundle that matches so isn’t the POST module only going to update that one record?

[samliew]

Your endpoint URL is still incorrect.

If you have any further questions, you can also repost in the Hire a Pro category if you find it easier to explain your problem over screenshare. There is only so much we can do for you on a text-based forum.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.