Important Update: Single Sign-On (SSO) for the Airtable Community will be required effective June 2n...
Ask questions, get answers and engage with your peers
New here? This is a great place to start
Get support directly from your peers
Celebrate your Airtable wins
Forge connections with other Airtable users
Explore and RSVP for upcoming events
Read the latest news the Airtable team
Hi! good day!I am currently using the formula below to determine if a record/records is within last weeks Sunday to Saturday. Sunday being start of the week and Saturday being end of the week. AND( IS_AFTER( {Time in}, DATEADD( DATEADD( TODAY(), -WEEKDAY(TODAY(), "Sunday") - 7, "days" ), 0, "days" ) ), IS_BEFORE( {Time in}, DATEADD( DATEADD( TODAY(), -WEEKDAY(TODAY(), "Sunday") + 0, "days" ), 0, "days" ) ) ) If today is the 20th of June then my Current formula will tag my June 8 , 8AM record as false. If I adjust the time to 8:30AM, formula will tag it as true, would like the formula to include the entire day of sunday up to the entire day of saturday. Appreciate the help!
Hello Airtable Community,I am hoping that someone can help me out with an automation that I am trying to build. I am new to Airtable and am figuring things out as I go. Well, trying to at least.We are a small behavior services company that works with adults with intellectual disabilities. Since our inception, I have been tracking how many hours we provided to each of our clients in Excel but it was too clunky so I have started using Airtable instead. So far I am impressed but I am having some challenges getting all the things I have pictured into my head to become reality in Airtable.So far I have built a base that has a couple of important tables. One that has the necessary information that I need to track for our clients including what services they qualify for, a weekly tracking sheet that captures each clients hours delivered for that week and a rate sheet which then can tell me what those hours translate to in terms of billing payments. I also figured out how to build a form
Hello all, We have recently implemented Airtable on our team to account for hours worked by employees. To gather the information, I created a form in which they answer at the end of every work-day to take into account the actual hours worked. These answers feed a database that groups every reply by week/employee. In the database, I created a column of “Work-day” which is the employee’s weekly hours divided by 5 business days. This way, when they answer the form, I would have the daily overtime and then it would be grouped weekly and it would give me the weekly overtime.However, the team is mainly composed by part-time workers and that’s where it becomes tricky. We don’t really enforce a fixed start/finish hour, so a person who has a contract of 18 hours/week, may work only 2 days one week and then 5 days the next week, picture below. What I would like for it to do, and that I wasn’t able to, is to calculate how much overtime (or time they didn’t work) they are doing per week, based of
Hello guys, I would appreciate it if I could get some help on this. So the context is that I have two tables. 1 table is for quotation (Tbl_RFQ) and another table is for when quotation is confirmed (Tbl_Confirmed). For example, an item in Tbl_RFQ may invite 3 bids (i.e., 3 records). However, only 1 bid will be selected for each item. When the winning bid is selected, new record will be created in Tbl_Confirmed. This requires an automation which I managed to do. Automation to create records in anther tableThe problem is that, most of the times, some details are not yet filled in Tbl_RFQ so it means that when new records are created in Tbl_Confirmed, some fields are missing. What I am trying to do is to link the created records in Tbl_RFQ and Tbl_Confirmed together so that if the fields in a record in Tbl_RFQ is updated then the same field in the same record will be updated as well.A simple solution may be to just create a lookup field in Tbl_Confirmed that links the two tables togethe
I have a decent sized based we’re using as a CRM. Every entry is tagged with a representative’s name in a single select field. Over time, some reps have come and gone, and I don’t want to have their names available to select for new enteries, but I don’t want to lose the data of who made previous entries. What I really wish I could do is toggle certain single select options on and off, but I don’t believe I can do that without losing the formatting that we have now, which is helpful. Anyone know a way around this? Screen shot below of what I’m trying to achieve. I do not want to use an interface to resolve this problem, as my team typically does not use interfaces that are built for them! Thanks for any advice you all might have!
Good Day I would Like to Attach a pdf document to a email when sending it from an automation. How do I do this?
Hi there,In order for me to create a junction table. How can I get certain data from one table to another? I am looking to get all submissions, team, month, points awarded. I would like it to move over these fields and when a new recorded is added for it to add those as well Is this possible?
Hi there, Is it possible when creating bar charts that you can have visuals like we do on Excel or powerpoint? For example On the X axis I want it to have the month, Y axis to have submissions made but the actual bar to show the each teams who have made submissions for those months. Essentially, for one month it will have 3-5 bars which represents teams A-E Thank you
I have started a blank canvas instead of using a template to show various data. Is there a way to use a pivot table within a blank canvas? I want to show points given by each team as the column and each row would be the team then across the top would be each month and then within each would be the number of points given. I would then want to replicate this with the amount of submissions example is below using the template
Hello,Am wondering if there is any way to have a table in page designer be dynamic in size? We would like to use page designer to generate invoices, but some clients have only a couple of lines while others have 15-20. The biggest current issue are the large invoices that have too many rows to fit into a one-page table. Right now, it just gets cut off. Is there a way to extend the table to a second page?In an ideal world, my total price, etc. fields would be at the bottom of a table that only is as tall as the number of rows in it, whether it is 3 rows or 30. Thoughts?Thanks,Alex
How can I default to opening bases from the icons as it used to be instead of it opening interfaces always when clicking on an app? Very inconvenient for many of my users.
I'm looking for a database that can perform Certificate Management System I must include the following Certificate Management criteria, Certificate Registration or registry storage ,Certificate Recognition Management, Certificate Compliant Management, Certificate Reporting Management, Certificate Assurance Management, Certificate Clearance, Certificate Accreditation Management, Certificate, South Africa Certificate Authority, Evaluation
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.