Edd_Turner - profile

Edd_Turner · Nov 16, 2020

Hello Dear Community! I am having not much fun concatenating minutes into hours. In the image, where it says (for example) 75.16 minutes in line 4, I would like it to say 01:15 (or even 01h:15m. My formula is below. I know it’s something to do with ...

Edd_Turner · Oct 12, 2020

Use case: At the end of my estimates (page designer), I want to put in an inspiring or humourous quote… but I don’t want to type it myself, just collect them in a field somewhere and have them appear with a formula. What kind of formatting/formula wo...

Edd_Turner · Sep 30, 2020

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,...

Edd_Turner · Apr 12, 2020

I think I’ve bitten off more than I can chew. I want my data in Airtable to flow into a snazzy PDF invoice. My data is spread across several tables (!) and now I need help to unpick my knotted CRM to enable this task. For example… Every invoice goes ...

Edd_Turner · Apr 09, 2020

Hello Airtablers! For my CRM I’m trying to automate the ranking of my prospects from “ :fire: Flaming hot” to " :skull: Dead". I tried using a SWITCH formula but got in difficulties, so I reverted to IF and DATETIME_DIFF. I want to switch between ...

Edd_Turner · Oct 13, 2020

Awesome, thanks! I’ll give it a go!

Edd_Turner · Oct 08, 2020

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!

Edd_Turner · Oct 07, 2020

I think I’ll have to re-read that 3 or 4 times, but will give it a go and report back - thanks! :thumbs_up:

Edd_Turner · Oct 06, 2020

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!

Edd_Turner · Jun 13, 2020

Where would a beginner go about learning this in an step-by-step way? Experience = 0. I mean, as Lisa Simpson says: „I know those words, but that sign makes no sense!“. Edd Turner Übersetzer, Dolmetscher, Sprachenberater und Dozent für Englisch M: ed...

User Statistics

User Activity

DATETIME_FORMAT conversions - minutes to hours (Concatenate)

SWITCH (?) to choose random entry from field? Or something else?

New data not reflected in fields, bases

Logical table setup for page designer - help!

Nested formula and DATETIME_DIFF not turning out, where is my simple error?

Re: SWITCH (?) to choose random entry from field? Or something else?

Re: New data not reflected in fields, bases

Re: New data not reflected in fields, bases

Re: New data not reflected in fields, bases

Re: Logical table setup for page designer - help!