

xReal, Double: Floating point number in double precision.Float: Small number in single-precision floating point.No sign, the range of values is 0 to 429 496 295 Integer, Int: Integer with or without sign.No sign, the value range is 0 to 16777215. MediumInt: Integer with or without sign.No sign, the range of values is 0 to 65535.

Sign with a valid range of values is from -32768 to 32767. SmallInt: Integer with or without sign.Bit ou Bool: Integer that can be 0 or 1, widely used when need to perform validations and conditional (true and false).No sign, the range of values is 0 to 255 Sign with a valid range of values is from -128 to 127. TinyInt: Integer with or without sign.This data type is used when you need to store numbers and they integer or decimal. In MySQL there are three major groups of data they are numeric, date and text. So let us know in the string data types that MySQL and so help you choose the best option when creating your tables and model your bank. Each column will be assigned a name and what kind of data you will store and for each type of information is required to indicate a compatible data type. If you've got a field called "Slack Channel" and have put in a value like #test or #live into the field, you can achieve the same results with one action and no if/else block.When creating a table is necessary to inform the columns that will be part of it as well as the type of data that will be stored. The if/else block logic would still be the same if you used the "Send Slack message" rule instead.Īlthough theoretically you could have a custom field for the Slack channel name, and then just call that directly as your smart value in the rule. An additional advantage is that by using webhooks, you can override the channel the message is going to instead of having to know its email address in advance. Hint: in the "Send email" action, you can start typing a pair of curly braces and Automation will suggest that the address you're putting in is a smart value:ĭoes your rule strictly need to send an email? Would it be possible to use the "Send Slack message" action instead, which uses webhooks? The formatting of messages coming in through webhooks is significantly cleaner than emails, as well as a little bit faster. Here's an example of the conditions and actions: You'll want to create an If/Else block to compare the values of your "TestFlag" field - and then as an action in the if/else, set a variable for the email addresses you want to use. To answer your immediate question, which seems to be "can I use a smart value in the To: field?", the answer is yes.
