Help

Can Someone Help?...How To Create Flood Expression in Integromat

Topic Labels: Formulas
4902 12
cancel
Showing results for 
Search instead for 
Did you mean: 
M_k
11 - Venus
11 - Venus

Hi

I am trying to change the decimal point in some numbers, to be used in Integromat, using ceil or floor options. I tried using the decimal option in GS, but it didn’t work.

Apparently, I need to extract the numerical value, by using split + get functions, then use the math functions floor or ceil. I wondered if someone can help.

I managed to create an expression, with some help, apparently I have to use “String” after ”Split” were “1.value” is, but I was a bit stumped, do I place a value there or use a tag? If it’s a value and I want to change the decimal position from 24.01 to 24, how would I write it? If it’s a tag, we’re would I find it? Also, were do I place the “Temperature: Day” tag?

Thank you,
Mary

This is what I would like to convert:

348F65D1-202F-4EF5-BCD1-B3EED2BAE4FD.jpeg 99EBDC06-FE3E-4218-8B3D-506F9A626CBF.jpeg

This is how far I got:

7A6399CD-8DC2-4989-8E9D-4E6A71BE780A.png

Thank you,
Mary

12 Replies 12

Hi @Justin_Barrett

Thank you so much for your help and patience.

I was looking at the weather data in GS worksheet and I did a test, with and without floor expression and I noticed there is quite a discrepancy with the data. I am realizing that I need a more accurate set of data, so for now, I think that I will try the scenario without floor expression.

In terms of formatting GS worksheet, by changing the the placement of the decimal, in each column, I made the changes that I want. The only thing I am noticing, is since I have added Gmail module to my scenario and when I check the email, the data does not show the same decimal format as in GS worksheet. I am guessing that’s because the body of the email in not in rich text format.

The only solution that I could think of, if it works, is to somehow get a link of the GS worksheet in the body of the email. Then I would just click on that to open the worksheet and therefore, see all the correctly formatted data that I initially made.

Unless, there is another way that I don’t know about.

Mary

The email body being rich text or not wouldn’t have any impact on the formatting of the data you’re pulling from GS. Just like when moving the data into GS from your initial data source, the data you’re pulling from GS to build the email is still just data, not data set to display with a certain format. Even though you formatted the GS cells to not show a decimal (i.e. displaying it as though it’s an integer), it’s possible (based on what I’ve seen so far) that GS still stores it as a decimal value. If so, that’s what will be passed to Integromat as you build the email. That means you’ll need to format it again as you add it to the email, and again, floor should do the trick.

Hi @Justin_Barrett

Thank you for your help.

I will look into the suggestions that you made.

I really appreciate your help.

Thank you,
Mary