Data Blaze with IF command

Questions and Help
1

Hello everyone,
I could use your help with Data Blaze, I have a simple data base with customers data (name, email, country they're from etc.) and what I want to do is to create a snippet which would load the specific list of email depending on the category, in my case it's country.
For example I have 10 customers from Japan, and I want to load all their emails, but I also would like to choose the country to Brazil next time, without going to the dashboard and manually changing the condition each time.
I guess IF command should help, but I struggle with implementing it.

Could you help me if this is possible in Data Blaze

2

Hi @StarChronicles ,
Welcome to Text Blaze community.

There are multiple ways and implementation might depend on how your data is configured.
For the simple data implemented, this could be one way

I used DbSelect to get all the customers in the data.

Used unique(map(customers, (customer) -> customer.country)) to get all the unique countries.

Used {formmenu: values={=locations}; name=country} to display a field to display those countries so you can select.

filter(customers, customer -> customer.country = country) to filter customers with the selected country

I also have a different implementation using where clause. Please check the other snippet named "Customers in country"

3

Hi @VinodGubbala ,
Thanks, I was able to do it finally, I appreciate your help.

I do however another interesting question: Is it possible to create any kind of timer in Data blaze table? I am filling my data base with customers data, and later after some time I want to send a follow up message or a newsletter, therefore it would be very usefull if there was a timer that would be triggered based on the date of creating each row of my database
image
There is a formula "datetimeadd" but I think this is not very useful in this case because it doesn't allow to enter the "created on" as a first argument
image

Please let me know if there is any way to implement this task, thanks.
P.S The text blaze and data blaze is a very powerfull tool, I hope it will have even more features in the future

4

Can you please help me understand how you want to calculate the remaining time you want to generate.

There are multiple ways you could do this, and I am sure you can use Created on with datetimeadd . The syntax should look like datetimeadd(`Created on`, 4, "D").

5

Hi Vinod - I just wanted to follow up on this topic, is there a way to make it so that "if one column/cell is filled" and then another column/cell is not filled with "yes" then a task is created, maybe through zapier or something along these lines?

A use-case example: If I am working with a buyer and the "Document Needed" row is filled with "Yes" and then 24 hours go by and the "Document Received?" column is not filled with "Yes" as well, then it triggers an email task, or pops up again within a snippet

I looked into the Zapier function "if row is updated", but it does not allow me to select specific cells within that row. My solution for now is to have specific "task" tables set up, where a new row is directly correlated to a specific task
image

6

Hi @ajduna7

You can achieve what you need using the following:

  1. Build a conditional workflow using Zapier's Paths, so that if the "Document needed" column is filled with "No", send the email immediately, otherwise, step 2.
  2. Use Zapier's Delay to wait for 24 hours then send the email.

This is the idea behind Zapier: you can combine tools to achieve your complex task.

Please let me know if this approach helps, also feel free to reach out again in case any further help is needed.

7

Hi Abdalla! Thank you for the response. The only issue I am facing is that it is not possible to select specific columns with the "DataBlaze Row Updated" Zapier "command". It gets triggered, if that row is updated in any way

8

@ajduna7 Yes, unfortunately, there's no way to detect changes for specific columns, the only option right now is to get triggered for the row being updated in any way.

9

Sure thing - I appreciate the response, As of right now I will just have tables that are designated for certain tasks to be completed :grinning: Simple enough

1 Like