CRAZY USECASE: Overloading app in a level that created hours delay in writing to Sheet

:zipper_mouth_face:

:rofl:

1 Like

@Darren_Murphy hehe, don’t tempt me. :wink: I don’t think you’re going to get much better than your current process right now.

2 Likes

I agree 100%!

If the conditions allow you, one must choose/use a notification (a exception write) vía Webhook instead of polling when you integrate several applications.

What I’m learning now reading @Darren_Murphy ‘s reply is how to send a POST via script to fire a Webhook:

If it’s been more than 90 minutes (SLA Breach), then it will send a POST to the Integromat web hook

Would you mind to share this part of your code in order to learn how to do it?
I have a couple of cases that will need this great feature!

Thanks in advance for your help and your other posts about JSON btw!

Saludos

4 Likes

Yes, tomorrow.
Not now because I’ve had too many :beers:
:crazy_face:

7 Likes

I missed the part that your time trigger in on the sheet. Of course, no problem with integromat. This is what I was saying why I can’t use glide tables for time trigger.completlly agree

3 Likes

Here is a simple example…

    function send_integromat_webhook() {
      var subject = 'Test';
      var recipient = 'user@example.com';
      var body = 'Just testing';

      var obj = {
        subject: subject,
        recipient: recipient,
        body: body
      };

      var json = JSON.stringify(obj);
      var url = 'https://hook.integromat.com/<HOOK_ID>';
      var options = {
        method: 'POST',
        payload: json,
        contentType: "application/json; charset=utf-8",
      };
      var response = UrlFetchApp.fetch(url, options);
    }
6 Likes

Great @Darren_Murphy!!

I owe you a :pizza:… too many :beer: without feeding block your mind :upside_down_face:

Feliz día!

2 Likes

@Mark_Turrell

If we use only Glide Sheets for one app, is it possible to connect a second App to the same Glide sheets? I think Ive only seen the option to use the same Google Sheet.

Is it the “Link to Glide Table” option when you try and add a new table?

Yep!

1 Like

It would be nice if we have action to copy glide sheet data to google sheet. Than i would love to use glide tables, please make set whole column action for transferring data

Are Google Sheets a good place for user profile sheets and can Glide Tables connect to Intergromat?

Users editing their profiles and selecting favorites are the only two things I can think of that might be happening simultaneously for a large amount of people.

Either are okay, but it really depends on your specific use case.
If you’re using row owners, but still want to make some data from your user profiles public, then it’s easier when you have a Google Sheet as the base. I generally always use a Google Sheet for my User Profiles, but that’s probably more personal preference than anything else.

Yes, via Webhooks.
You can also send webhooks using Apps Script. Personally, I use one or the other, depending on the situation. The main limitation with webhooks from Glide Tables, is that it can only be event driven. ie. as a result of a user tapping a button or some other actionable component. Whereas with Apps Script, you can create scheduled (time-driven) webhooks.

2 Likes

Ok thanks! How is it harder to make the data public in the glide table?

Down the line I’ll be implementing redemption function within my app, I feel I may run into this issue.

Well, with Google Sheets it’s very simple to create a read only copy of your User Profiles sheet using an arrayformula. (I seem to recall helping you do this with your app a while back). You don’t have that option with Glide Tables, and in fact I’m struggling to think of a straightforward way to do it.

1 Like

Oh I see what you mean! Visibility within the sheet itself. Do you think I may run into this kind of issue with a redemption function where many users may be clicking a button to redeem a product at the same time? A user has to click a button titled ‘redeem’ which where the button ‘used’ is then displayed. The user then clicks the ‘used’ button to finish off the process.

Are you concerned about the possibility of two users redeeming the same voucher at the same time? (and what the result would be if they did?)
That’s really a separate and unrelated issue, and honestly I don’t know what would happen. This potential issue has been discussed before, and a few of us have agreed that collisions are in theory possible. But I don’t know that for a fact, and have never seen any evidence of it happening.

1 Like

I was just thinking of the delays in writing to the sheet as mentioned in this thread. Step 1 needs to happen before Step 2. If many users are completing Step 1 at the same time I am wondering if there will be an extended lag where Step 2 will take some time to show up for users.

Is step 2 dependent on data syncing between Glide and the user device? (It sounds like no). If that’s the case, it shouldn’t matter how many users are doing it at the same time, as the actions happen on each users device.

1 Like

In Step 1 and 2 data gets written to the glide data editor. The date and time both are clicked.