Archived from the Bravo community forum (2021–2026). Some answers may refer to older versions of Bravo.
Hi everybody 👋🏼
I share to you the links to an app I made for a swimclub. For this, I started to learn Figma that I absolutely didn’t know before, I had to learn how an API works and so on..
Here is the link for AppStore :
https://apps.apple.com/be/app/msc-swimming-team-dison/id1606745173?l=fr
Here is the link for PlayStore :
https://play.google.com/store/apps/details?id=app.bravostudio.A01FNH89GB3DV5Q0VPRQDY755Q4
I’m taking advantage of this thread to ask you if you guys could
- check this app and give me feedback
- throw ideas on how I could display swimmers best times in a specific format (0:00,00) instead of having the seconds (so 1:01,00 instead of 61)
- throw other ideas 💡 ? 😁
15 replies
Looks great ! Congrats and thanks for sharing :)
Nice and clean design! Thanks for sharing 🌟
Regarding the time format:
Which backend are you using for the content? For example, Airtable has a "duration" type column which automatically display seconds to h:mm:ss.ss format
Thanks, glad you like it 😁
Oh that’s weird ! I use Airtable and I use the duration field you are talking about.
Here are my fields and what the app returns :
Thanks Javier 🙏🏼
I see!
It seems the Airtable API sends the duration value in text format rather than the time format (so the data received is 126.29 instead of 2:06,26).
In this case, your best option is to convert the duration column into a text column and manually input the time in "m:ss,ss" format.
yep, that’s the solution I wanted to avoid 😅
I have 60+ columns to convert 😭
Hi ! Just for you to know that your app have country download restrictions.
Ow.. weird because I selected all the countries for both Android and iOS. And I saw users from Brazil and US downloaded the app.
On which the platform are you ?
Im on android and from Portugal
Good, I’ll check that for next build
Should be available on Android everywhere now 😃 I don't how long it takes for the update to be live.
👍
Found a solution to this problem. Maybe it can be simplified but it exists and it works haha.
What is does :
- duration storage from seconds to hundredths
- separation in 3 parts (minutes, seconds, hundredths)
- concatenation with ":" and "," to format like this -> mm:ss,SS
Be careful, here's the (really simple) formula 😂
CONCATENATE(IF(LEN(ROUNDDOWN(Temps*100/6000,0)&"")=1,"0"&ROUNDDOWN(Temps*100/6000,0),ROUNDDOWN(Temps*100/6000,0)),":",IF(LEN(ROUNDDOWN(((Temps*100)-ROUNDDOWN(Temps*100/6000,0)*6000)/100,0)&"")=1,"0"&ROUNDDOWN((Temps*100-ROUNDDOWN(Temps*100/6000,0)*6000)/100,0),ROUNDDOWN((Temps*100-ROUNDDOWN(Temps*100/6000,0)*6000)/100,0)),",",IF(LEN(ROUND(Temps*100-ROUNDDOWN(Temps*100/6000,0)*6000-ROUNDDOWN((Temps*100-ROUNDDOWN(Temps*100/6000,0)*6000)/100,0)*100,0)&"")=1,"0"&ROUND(Temps*100-ROUNDDOWN(Temps*100/6000,0)*6000-ROUNDDOWN((Temps*100-ROUNDDOWN(Temps*100/6000,0)*6000)/100,0)*100,0),ROUND(Temps*100-ROUNDDOWN(Temps*100/6000,0)*6000-ROUNDDOWN((Temps*100-ROUNDDOWN(Temps*100/6000,0)*6000)/100,0)*100,0)))
👏 Awesome! No code yes formula 😂
Did you create one formula column for all 60+ duration column? or one each?
I adapted the formula for each field so I have double columns 😅
Lucky AT doesn’t charge columns but rows haha
Wrote something in this thread and want it removed? Request removal
Ask the community on Discord
This archive is read-only. New questions, office hours and product updates now happen in the Bravo Discord.
Join the Discord