Other Questions

I would like to create a daily log to track how often I got up from my desk to take a brief walk. How would I go about counting the number of times I did it? Here’s what I did so far: Row A (“Date”) Column 1 (Checkbox) Column 2 (Checkbox) Column 3 (Checkbox) Column 4 (Inserted this Formula: SUM({Break1}+{Break1}+{Break1}) It seems like overkill, though, to have to create a new column to track each activity. Is there a simpler way I can do this?

Is there a way to share Views without requiring recipients to create an Airtable account?

I need to invoice/quote customers with layouts that include both text and images. I’m trying to increase the image size of a record but can’t seem to do so. Is there a workaround?

I’d like to embed a view of a specific record on another web site. I’d like to specify the record id / view id on the URL so I don’t have to create a custom view for each record, which is a waste of time. Ideally, I’d like to just embed in an < iframe > the expanded view of a specific record in a view. I’ve tried the following and it displays an unhappy face: < iframe src=“https://airtable.com/tblhtZEdSQOe7XDl1/recP1MM6ZUrqKfpJy” frameborder=“0” onmousewheel="" width=“50%” height=“533” style=“background: transparent; border: 1px solid #ccc;”>< /iframe> The user viewing this webpage will have login access to Airtable. Alternatively, if I could pass in the record ID into an embedded view that would work as well. I know I can filter within the view, but can I specify the filter options on the URL of the embedded url?

Hi all i have tried to “send a record” from a couple of my bases both in free workspaces and a pro plan and i never receive the email i get the pop up of the record enter the email and send and that is the last i see of it. is there something i need to set up? or am i not doing something ? Many thanks for your help Ian

I am using Airtable to collaborate with a group of people with varying permission levels. In some instances as we are working on updates to the Base content, we only want certain permission levels to see the updates being made whilst the rest of the Base should still be accessible to the team. Once these updates are complete, I would then want to publish them for all in the Base to see. Ie. is there an option to add things which only certain permission levels can see and which others (with reduced permission levels) who already have access to the Base can not see until it is ‘published’ for others in the Base to view? Many thanks in advance.

Hi all, I have one table in a base that I would like specific persons (not necessarily collaborators, but Airtable users) to be able to view (and ideally edit), without granting them any access to the rest of the base. I understand that this is not possible as collaborators have access to the whole base and not parts of it. Let’s call this table “Tasks”. I would like specific employees to be able to see, for example, what tasks they have been assigned, their deadlines and so on, without giving them access to other tables within the base nor all of the linked records in the “Tasks” table, which might contain confidential information. I thought of creating a different base that would be automatically populated only by the said table (“Tasks”) but again linking between bases is not supported (I will have to copy/paste records, which is not quite the idea for what I’m trying to achieve here). Any ideas on how to get around this? Thank you! Crisa

Here is the code I am trying to save but keep getting errors. Any ideas? IF(OR({Do you have all the Information needed}=“No”,{Do you have all the Material you need}=“No”),CONCATENATE({My Name},“Can’t perform”{Production Goal for the day/Week:})

I’m using the Displaying quarters in fiscal year formula in one of my tables, however, for some reason, Q4 months are showing up as Q1 in my table. The formula I’m using is below. Here is a snippet of my table Here is the formula listed below: IF(OR( FIND(01,DATETIME_FORMAT({Date},‘MM’)), FIND(02,DATETIME_FORMAT({Date},‘MM’)), FIND(03,DATETIME_FORMAT({Date},‘MM’))),“Q1”, IF(OR( FIND(04,DATETIME_FORMAT({Date},‘MM’)), FIND(05,DATETIME_FORMAT({Date},‘MM’)), FIND(06,DATETIME_FORMAT({Date},‘MM’))),“Q2”, IF(OR( FIND(07,DATETIME_FORMAT({Date},‘MM’)), FIND(08,DATETIME_FORMAT({Date},‘MM’)), FIND(09,DATETIME_FORMAT({Date},‘MM’))),“Q3”, IF(OR( FIND(10,DATETIME_FORMAT({Date},‘MM’)), FIND(11,DATETIME_FORMAT({Date},‘MM’)), FIND(12,DATETIME_FORMAT({Date},‘MM’))),“Q4”))))

I want to use a project management base and then create reports for the executive team to show our progress. Can I create a report? Can I customize it to an in house standard template or a totally custom report with graphics without leaving Airtable? Thank you in advance for your comments and advise!

Hi there! I see that if you change the end date of a predecessor to end later than the start date of any of its successors, the start dates of those successors will change automatically. However, I’m curious if there’s a way to do two other things. Automatically compress the time between variables to start the next day. For instance, say I’m eager to make a cake and two of my variables are making the batter (which takes me 2 days) and baking the cake (which takes me 1 day). If currently taking the batter is on Monday and baking the cake is on Friday is there a way to shrink this time, so baking the cake would start as soon as making the batter wraps up. Or do I have to do that manually? Automatically have a successors move up in time when you move a predecessor up in time. So, once the two variables are happening the next day. So making my batter would start on Monday, it would take me two days, and then baking the cake would star

Is it possible to map header fields so that I can import an Excel spreadsheet into an existing table that has several different headers?

I need to link a table of 1 base to another base : is it possible? or : how can i copy a table of 1 base to another base without retyping everything? thanks !

Imagine this scenario - I want to create an invoice line. I have a product table of product_code and sales_price. I have the product code and quantity in the invoice line table and want to lookup the sales_price and copy it into the invoice line table field sold_price_each. I can do it with a lookup but that has a problem. If the price of the item changes in future, then the invoice will change after it’s been issued, which is no good at all! I am new to Airtable and cant see a way forward on this one. Any help appreciated.

Hello! New to Airtable, and wanting to explore using the gallery view as a front end for an application catalog of tools available at my company. The gallery view is almost perfect, but I would like to be able to link directly from the gallery card without forcing the user to click on the card, then click on the URL. Is there any way possible to remove the second detail pop-up and have the card directly link to a detail page on our intranet? Example gallery view: Redundant popup I want to remove (and link directly from the card to the URL): Thanks

Can someone please share what formula I would use to update the day for holidays that change each year? For example, MLK Day, President’s Day, Good Friday, etc. all change each year. I’m using a social media calendar template and the current formula is not auto-updating the holiday dates for 2020.

Hi all, I came across an article saying https://www.supportcolumbuseats.com/ was created to help covid-19 affected restaurants in Ohio using Airtables and Squarespace. I am trying to do something similar for the affected restaurants in my area. How do I use Airtables to create the checkbox filters? Thank you.

Hi there, I have linked two tables & then a data column was lookup in the second table. But, when I created a form I cant see the lookup field in options. Is there a way so that we can add the lookup field in forms? Thanx!!

I am creating quote base. It would be helpful for me to get auto suggestion of list of words if I type the same thing in the cell that’s been rooted in the same column. So that I can I avoid duplications. Is there anyway to do this? Thank you so much in advance for your kind support.

Hey All! Here’s what I’d like to do, not sure HOW… Notify Teams of people at once when a new record is added. I have a list of team members, working on multiple projects. For example: Bob works on project 1 and 2 Bill works on project 1 and 3 Sally works on project 2 and 3 I want to assign people to these projects as a TEAM. For example: Project 1 - Team 1(multiple people linked) Project 2 - Team 2 (multiple people linked) Project 3 - Team 3 (multiple people linked) Then when I add a record - have a field that has TEAM as an option, and when I select Team 1, all people associated with Team 1 would get a notification. The same way as a collaborator field would do but with this Team group. I can see making the groups with people and linking the tables, but how do I get the Team selection to send out the notification. Thanks in advance for any/all help! Cheers

Hello I created already a few Airtable database, although I’m still a newbie :winking_face: Before I start a database and table design, I try to make a drawing on paper, with the different tables, and especially the fields that are linked to another record and those that lookup information in another table. If you get these right, you’re more than halfway :winking_face: Today I still use pen and paper to get the design roughly and with arrows drawn on paper, I can see the relationship between the fields in the tables, before I start programming. My question is : Is there a handy tool, cloud-based and free ;), that would make these drawings and the design of the database easier ? And if this simple tool would have an export to Airtable, so that you have already the database with the relational fields, that would be a great bonus :winking_face: Thanks for your suggestions, Michel

Good morning, pretty new Airtable user, but liking it so far. I’m running into a challenge with this requirement: I need to take a list of sales managers, reference their staff, based upon multiple tiers, referencing the sales staff’s number of sales, and calculate a bonus amount for the sales managers. I’ve considered linked tables, scripts, and junction tables. I can’t SEARCH/FIND for this nor create an IF statement that’ll do it. I’m unsure how a Junction table would help, and haven’t really dug into the script block yet. Basically I need to find an employee ID in another record, as referenced in the “manager ID” field of the original record, and then pull data from another column (sales numbers). This would be trivial in a Google Sheet/Excel, but no go so far. Ideas would be much appreciated, with code examples if possible, thanks much!

Hello everyone, I am trying Airtable to prepare some reports. For this purpose, I need to create a graphs to represent month on month change in planned numbers as compared to actual numbers. For Exmaple, I have 5 projects, say - P1, P2, P3, P4 and P5. I have planned some hours on each project for May and June. I am also tracking my actual work hours on these. We can use this data for create a graph: |Project|Month|Planned Hours|Actual Hours| |P1 |May|15|18| |P2|May|18|12| |P3|May|25|30| |P4|May|20|23| |P5|May|22|16| |P1|Jun|20|10| |P2|Jun|25|27| |P3|Jun|15|20| |P4|Jun|23|15| |P5|Jun|30|40|

Hi everyone, This is my first post here. Hoping to get ideas that could solve my problem. Here’s my setup: I have a table where I upload CSV files to. Each row contains, among other information, a price and an attribution to both an item and a vendor. I decided to list the prices in rows and not in columns (as often seen in the forum). Existing records are merged by a unique value consisting of the vendor’s name and the item’s name. As you can imagine, there can be different prices for one item from different vendors. One item can “occupy” up to 5 rows. So although I only have 10’000 items, the limits of my base in PRO can easily be reached by this setup (by the way, if you have an idea how to set the whole thing up more effectively, please let me know :slightly_smiling_face: . To save space, I thought about only keeping the two lowest prices for each item. As for the more expensive prices, I want to create a view in which I can eas

From what I’ve read about the field permissions this isn’t possible, but I hope someone has found a workaround for this? Without Forms, preferably! On View 1 I’d like a field to be utilized by all. then as the workflow progresses and moves to view 2 this field is locked to prevent the user from making changes to the filed and so on.