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

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:

This is how far I got:

Thank you,
Mary

Based on your screenshots, I can only see that you’re using Google Sheets and GMail. It looks like the portion of your scenario in question relates to Google Sheets, and not Airtable. This forum is for neither Google Sheets nor Integromat so I’m not sure how much guidance any of us here can give you. I for one am not experienced enough in Integromat’s formulas to provide an answer, sorry.

It looks like you’re rounding down in all of your examples, which would use the floor function, as shown in the examples in your first screenshot. The formula in your second screenshot is more complex than you need it. Just put the value from step 3 (i.e. 3. Temperature Day) inside floor(), and it should do the trick.

Hi @Justin_Barrett

I think I did what you suggested correctly, but it did not change the night temperature.

Hi @Kamille_Parks

Thank you for your reply.

Mary

Your screenshot shows the formula, but obviously I can’t see the before and after values of the data. To confirm that a desired change is really being made, what I’ll sometimes do is make the output a longer string that shows both before and after values, separated by some obvious divider like a vertical bar. If you do that, take a screenshot of that combined output so we can see what (if anything) is happening.

Hi @Justin_Barrett

I tried to do the changes that you suggested. I am not sure if it worked, since it did not move the decimal point.

Here are screenshots: #1 Google Sheets, #2 Google Sheet module, from Integromat, #3 how the results look in my Google email, the day and night temperatures (which are what I am working on) are right after the time.

Thank you,
Mary