Eric_Bryant1 - profile

Eric_Bryant1 · Feb 06, 2023

Hi,Am using a formula I've used in bases before, but it's behaving strangely. It's subtracting a day off of the returned value. I have two fields with dates. Only one of the two will ever have a date in it. I want the formula to grab the date fro...

Eric_Bryant1 · Feb 03, 2023

Hi there,I work in the film industry and am trying to create a base to help me track my work.I make graphics for sets. A graphics might be something that hangs on the wall in a set, so it would be in every scene that's shot on that set. Or it might...

Eric_Bryant1 · Feb 01, 2022

Hi, I use Airtable to track information for film and television production. I frequently need to sort a list of scenes by scene number, but scene numbers often have letters added to them, which screws up the sorting. Example list, which I would want ...

Eric_Bryant1 · Aug 09, 2023

+1

Eric_Bryant1 · Feb 06, 2023

It was totally a time zone issue! thanks for the clue!

Eric_Bryant1 · Feb 06, 2023

Thanks! I'm going to play with this. I'll report back if it works.

Eric_Bryant1 · Feb 02, 2022

Thank you so much @Justin_Barrett ! This is such an elegant solution. I’m going to try to better understand your formula in the hopes of furthering my own knowledge. After I saw this I realized that there is a scenario that I had forgot to mention. ...

Eric_Bryant1 · Feb 02, 2022

In theory it could go as far as Z, but i’ve never seen it. If a screenplay needed that many revisions, I’d say it’s back to the drawing board. :grinning:

User Statistics

User Activity

Date Formula Subtracting A day

One to Many to One

Automating sorting for Screenplay scene numbers

Re: Embedding Interface on the web

Re: Date Formula Subtracting A day

Re: One to Many to One

Re: Automating sorting for Screenplay scene numbers

Re: Automating sorting for Screenplay scene numbers