ianonline - profile

ianonline · Aug 19, 2023

Hello, I'm frustrated! For nearly two hours I've been looking at Airtable documents trying to achieve what I could do in five minutes with a spreadsheet using the filter or query functions. There are a few recent posts on the same subject but each ca...

ianonline · Oct 16, 2021

Hello, I have one table and would like to sync the primary field with the primary field in a second table. I tried this by creating a synced table, but the only bases available are the example bases. I moved my table to the example bases workspace, b...

ianonline · Sep 09, 2021

Hello! Can anyone advise on the IF formula to state if a date has passed a number of days? So if the date in “DATE” column is more than 60 days ago, then :white_check_mark: or :no_entry: . I’ve been looking through date and time functions in the F...

ianonline · Sep 09, 2021

Hello, I’m trying to get a formula working to determine age in years with one decimal place. The date is in a column called “Created”, the formula I’ve got is: DATETIME_DIFF(TODAY(), Created,'years') & ' years' Can anyone help add the decimal place ...

ianonline · Sep 09, 2021

Hello, can I use date DD-MMM-YY date format like I can with Jotform? Some services will only use the American date format, so I like to use MMM for the month letters, otherwise it’s very easy to mix up the day and month. Tomorrow for example is 10/9/...

ianonline · Oct 16, 2021

Thanks kuovonne, I’ve had a go with automations a little before and it works well, although I can’t see how that would work for this. I might do better to just copy and paste the specific items into a new table but I don’t know if the product should ...

ianonline · Oct 16, 2021

Hi Justin, thanks for your help. Yes, I do mean within the same base, but it appears now that maybe Airtable isn’t suitable for this specific need. The primary field is a list of products, and I’m needing a way to organise contact with around 20 pros...

ianonline · Sep 12, 2021

Dominik_Bosnjak: IF(DATETIME_DIFF(NOW(),CREATED_TIME(),"days")>60,"✅","⛔️") Thanks Dominik, this worked perfectly after changing CREATED_TIME() to the referenced column.

ianonline · Sep 09, 2021

Thanks for the suggestion, if possible I’ll avoid overcomplicating it, so I decided to just make it count the number of months.

ianonline · Sep 09, 2021

Thank you kuovonne. It’s not ideal, but I guess it’s the best solution.

User Statistics

User Activity

Linked record or Lookup, or both?!

Help sync primary field

IF dates past 60 days then :white_check_mark:

Help calculating age (since date)

Can I use date DD-MMM-YY date format?

Re: Help sync primary field

Re: Help sync primary field

Re: IF dates past 60 days then :white_check_mark:

Re: Help calculating age (since date)

Re: Can I use date DD-MMM-YY date format?