Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Base Design
- New data not reflected in fields, bases

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Topic Labels:
Base design

Solved

Jump to Solution

0
2504
6

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sep 30, 2020 03:52 AM

Phew! Lets’s see if I can explain this clearly.

Almost daily I go running.

I keep a log of distance and time and get a kick out of recording and graphing the results.

In Airtable, I’m using the chart app to chart several bits of data (DIstance, Time, s per km, s per mile, speed, etc.)

For the straight forward data (duration, time) Airtable has no problem making charts for me, they look great!

But, Airtable won’t let me make a chart with duration. No problem: the current workaround is as follows (example to calculate km/h):

- Insert Distance as Decimal in “Distance” field
- Formula -> convert to m (divide by 1000) (new field)
- Insert Duration as Duration in “Time” field
- Formula -> convert to s (divide by 60) (new field)
- In “km/h” field, formula {distance}/{time}*3.6

This then gives speed and so far has been carefully charted every day without fail

But when I try to do something else (e.g. duration for fixed distance - mins per km) the fomula works for all previous entries but never the new ones!

Method:

- Insert Distance as Decimal in “Distance” field (as above)
- Formula -> convert to m (divide by 1000) (new field) (as above)
- Min/km field - Formula ({Time}/{Distance}) (works fine)

**4. Km time - identical field as point 3, but with "number"**

**5. Comes up blank, doesn’t chart**

I hope that’s clear - what have I missed that the field doesn’t calculate (and therefore won’t appear on the chart?)

I’m hoping to solve this soon as if I need to rebuild the whole thing then it won’t be too big!

Thanks in advance

Edd

Solved! Go to Solution.

1 Solution

Accepted Solutions

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Oct 07, 2020 07:27 AM

`{min/Km}`

as the formula. See what happens!

6 Replies 6

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Oct 04, 2020 10:10 AM

Hi Edd,

Can you provide a screenshot of the base and the formula that’s not working?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Oct 06, 2020 12:28 AM

Sure!

Firstly, here’s the base:

,

And here’s the first instance of numbers not converting (copying, as the field is a duplicate) from mins to sec…

Let me know if you need more!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Oct 07, 2020 07:02 AM

I think I see what’s happening - let me know if this sounds right to you. The “Number” field type does not support formulas. In other words, if you switch from “Formula” to “Number”, it will stop calculating, and become a static field. If your intention is to convert mm:ss to seconds, you can do that with a formula!

Is your min/Km field is formatted in mm:ss? If yes, make the sec/Km field a formula field. Then just put the `{min/Km}`

field into your formula without any calculations. It should automatically show the units as seconds.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Oct 07, 2020 07:12 AM

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Oct 07, 2020 07:27 AM

`{min/Km}`

as the formula. See what happens!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Oct 08, 2020 09:11 AM

Brillant - thanks!

I think I thought a chart couldn’t reference a formula - guess I was wrong!

Now if only I could make a chart showing minutes and seconds instead of just seconds - that yould be perfect!

Reply