Forum Documentation Showcase Pricing Learn more

Format Repeating Group Text as Integer


#1

Dear Bubblers,

Please I need help on how to format my repeating group as integer.
I have a thing in the database that the value is an average of items.

I get values like 7.1112334, how can I format the text on the RG to 7?

Or better still round up or down?

Thank you all.


#2

:ceiling


#3

:slight_smile:great. Worked like a charm!


#4

I need your help on this thread topic please.


#5

you was already given good advice, try follow that.


#6

Thanks. Unfortunately I cannot seem to get it to work.
Breaking down the workflow is a challenge, I ended up messing up the entire app.

Poor me…


#7

its because you are writing lots of data too, not just the searches.

Uhh rethink your logic, stock replenishment can be loaded in a state instead of db and update that state whenever workflow is completed. Sales man average sales isnt so important to calculate it every sale, can do that on a button click or end of the week type thing.

your method looks too complicated, tell me what you are trying to build (in very simple terms) and i will redesign it for you when i get the chance.


#8

Thanks for your time.

Summary of app: Its a 3 in one app, a stock management app and a sales recording app and replenishment generation.

  1. I have a product, whenever the customer sells, the stock database is reduced by the quantity sold, the sellout db is updated with the quantity sold so I can get an average. When the stocks reaches a limit, I can generate a replenishment, that’s the entire summary.