Shiro

Any ideas for a workaround if my trigger needs to work on more than 10,000 records? As I check, we cant use the same workaround for the task, so... ?

@NiceDuck or create a formula field and use this formula instead: CONVERT(VARCHAR(8),convert(datetime,[@field:EmailSent],101),114)

You do realize that you can also just use the same formula for the time values to make them 00, right?

I agree, @NiceDuck, However, you must set the extra table as read only. DO NOT ALLOW any applications to change/update records from extra table as it will cause chaos on the data integrity.

I suggest that instead of using a calculated field, create an extra field on your table and use triggered actions to perform the calculation for you. Since it is a normal field, you should be able to group your values from it.

Do you still need help here?

I just noticed that one of our logout links is redirecting our users to Caspio Homepage (https://www.caspio.com/) when logging out instead of our designated logout page. Any Ideas?

I just got a word from support that Task can only process up to 10,000 number of records only. Is there some we can still run the task if you have more than 10,000 records?

Hello, Anybody has an idea why the Join types on my table relationship is greyed out? I cant change the Join Type...

Hmmmm... I tried that too, however the combined chat and report is actually just a single datapage. Kinda like the extra details page when you enable the details page option. But still, they are still the same data. If you want the other chart or the table to contain different information than the other, you will really have to create another one.

Yes @NiceDuck, they are indeed being ran at the same time. However, it was mentioned there that the other task should be Qued and shall be ran after the others. Mine is not running even though I try to run it manuallly.

I have a scheduled import on my Dropbox account. As I checked, 4 out of 7 of them is not being ran. Any Ideas?

I just want to share this. If you ever need to prevent your triggered action/ task on sending emails/sms on certain numbers. You can create a table which contains all those unwanted email addresses/ phone number and create a blocklist. It is just an extra condition on the where statement if you used a 'select from' block. Hope it helps...

It is possible to submit an email to multiple addresses, that are just on different fields of the same record? ex. On your record, you have 2 fields containing different email, lets name it field 'Email_primary' and 'Email_secondary'. Would it be possible to send email on both of those fields with only one email block?

Cool, Would it be possible to send those Barcode Via Email? Also, would it be readable by the barcode readers?