Showing ideas with label formulas and calculated fields.
Show all ideas
Submitted on
Nov 21, 2018
11:48 AM
Submitted by
typo
on
Nov 21, 2018
11:48 AM

When I use a lookup table to reference an e-mail address, url, or phone number in another table, I would like those fields to act as active e-mail addresses, urls & phone numbers when they are displayed in the lookup table. Currently the lookup table formats them as text, so if I want to e-mail a group of people from a particular set of lookup fields, I have to hand copy all of the e-mail addresses. Or, if I want to text someone from a particular lookup field, I have to hand copy the phone number.
... View more
Status:
Already in product
Submitted on
Nov 19, 2018
04:14 AM
Submitted by
Kofifus
on
Nov 19, 2018
04:14 AM

This is useful to look at the records you just or recently added. Thanks!
... View more
Submitted on
Nov 14, 2018
03:24 AM
Submitted by
Goce_Ristov
on
Nov 14, 2018
03:24 AM

What I find lacking over and over again is time when a field(not record) was last updated. Example: I have a field status. I need to know when the status was changed from In Progress to Completed. That way I can group all Completed tasks by month and calculate pay for this month. I think it is not too much to ask and it is a very basic and must-have feature for a project manager softwaer.
... View more
Submitted on
Oct 28, 2018
11:50 AM
Submitted by
SpatialAnomaly
on
Oct 28, 2018
11:50 AM

Like a standard number field in HTML. It’s kind of annoying when I’m logging time on a task that I have to mentally add up the hours I worked to the hours already present in the field from my last session with the task. It would be nice to just click an up arrow like 2 times to add 2 hours to the existing value. I realize that is not complex math to perform in my brain but it’s more about speed than anything. I don’t even really want to look I just want to add 2 hours to the task. We have used Liquid Planner in the past and although I have my gripes with that platform the way they handle a time log field is perfect, it just adds to the previous values whatever you type in there. That kind of functionality would be great but I’d seriously just settle for some up and down arrows, I can’t speak for everyone but I usually just round up or down anyway. Unless I’m missing another field time for this kind of functionality but I didn’t see anything that stuck out to me.
... View more
Status:
Launched
Submitted on
Oct 22, 2018
02:19 PM
Submitted by
Katherine_Duh
on
Oct 22, 2018
02:19 PM
UPDATE 2: last modified time is now available to everyone! You can learn more about it here. UPDATE: The last modified time beta is now closed as we get ready for a general release. Thanks to all of the testers who made this beta a success. ORIGINAL POST: Hi folks! We’re very excited to announce that we’re beta testing a last modified time field type, as well as a LAST_MODIFIED_TIME formula function. Many thanks to the users who’ve posted specific, detailed feedback about their needs and use cases with regard to this feature, like @Arlo_Haskell, @Deborah_Buck, and @Jordan_Friedman. We read everything that is posted here in the forums and your feedback is incredibly valuable for us when we’re planning the product roadmap and developing new features! If you’re a Pro plan user and you’re interested in testing out the last modified time field type and/or the LAST_MODIFIED_TIME formula function—and giving us your feedback—please sign up using this form. (Note: this is a different form from our standard beta signup form, and it requires you to fill out a couple of additional questions.) As you are all aware, this is a highly anticipated feature, and there are many users who would like to get beta access. However, for technical reasons and to ensure an optimal user experience, rollout for this beta will be conducted in small, limited batches. (In practical terms, that means that it might take a while for you to get access.)
... View more
Submitted on
Oct 11, 2018
05:07 PM
Submitted by
kc01
on
Oct 11, 2018
05:07 PM

It’d be good to have a formula that accepts a cell ID as it’s only argument and returns a date-time record showing the last time that field was edited. For example, you could have a to-do list with Doing, To-do, and Done as the options for a single choice field and then a column next to it showing when that field was last updated. How things are currently, if we want to know how active some team members are on their progress, we have to open every field one by one and check the change logs individually. Cheers
... View more
Submitted on
Oct 08, 2018
06:14 AM
Submitted by
Mathias_Elmose
on
Oct 08, 2018
06:14 AM

Would like a chat block :pray: I know that lot of communication happens in Slack but I think that it would be useful anyway Here is how it could work: A chat block could be set to display comments from records across the entire base from the views of your choice. So it would be like a basewide activity feed. Like the activity feed, you could select whether you will see activity and comments or only comments. Sometimes I miss the ability to quickly see what has happened in the base since last. With the coming block dashboard you could create a dashboard for certain teams and add chat blocks only for them, and that would only show records comments from the views that were relevant to them I actually think that a lot of our Slack channels would end up as Chat blocks if this was an option. It would also give people a sense of being together in a base and not just working together on it.
... View more
Submitted on
Oct 02, 2018
01:06 PM
Submitted by
Sam_Sandweiss
on
Oct 02, 2018
01:06 PM

Hello! Love this software. Starting to use it for post-production supervising in film and I was wondering if there were any plans to spruce up timecode support? Right you have duration which does, HH:MM:SS, but it would be great to get HH:MM:SS:FF, and different framerate support as well. Would also be amazing to add, subtract, and convert these values to different framerates. Anyone know of another way of doing this? Was thinking about doing a bunch of formula fields to manually calculate, but I’m thinking I might just use my google sheets script to calculate everything out first. Thanks,
... View more
Submitted on
Sep 21, 2018
01:17 PM
Submitted by
Lauren_Zinsmeis
on
Sep 21, 2018
01:17 PM

It would be very helpful if I could link tasks as dependencies (which is already possible) and have my dependent task start dates calculate off its predecessor’s end date. Just like in MS Project, all users would need to input would be the predecessor and duration, then the start and end dates would be automatically calculated. For now, I’m having to use MS Project or Excel to calculate all the start and end dates based on linkage and duration, then copy/paste that information into Airtable for every single task. When a task date changes, it could impact dozens of other tasks’ timelines. Using only Airtable, I would have to manually check every single task (my projects have upwards of 100 tasks) to decide if it is impacted by the change, and then calculate and update the dates for every impacted task. This is very time consuming so when a client asks “what is the total impact if I’m 4 days late with this task?” I can’t just make the update and see the change. I have to use a separate tool to calculate that change and get back to them with the response. Needing to rely on a separate tool also means I have to maintain all tasks in both tools. When anything changes, I need to record it both in Airtable and in MS Project.
... View more
Submitted on
Sep 20, 2018
09:14 AM
Submitted by
Amanda_DiRienzo
on
Sep 20, 2018
09:14 AM

Is there currently a way to show multiple color codes for each record on grid view? It seems somewhat pointless to just have the option to have a color code “alert” for one thing, even if there is a hierarchy for what color shows. I need to be quickly alerted of multiple things!
... View more