Solved

Hi, When I access a table-view through an API, fields that don’t have any values are not returned for that record in the API. Is this expected behavior? Regards, Ruchika

I am asking for some advice. I am working on a problem that I have with my Base. That problem is that I am attempting to automate data updates to one table from 4 other tables on a weekly basis. The puzzle is that I am tracking events that occur on each of these 4 tables on a weekly timeline. These events are by employee, in the case that they incur a trackable event on that week. We are tracking these events on a week (or month) per the time stamp on each occurrence. Each event results in either a positive or a negative score. This score is then subtracted/added to/from a credit on a different table. I have run into two problems. First, I tried to roll up each occurrence on the Employee directory. Rolling up there created an accumulation of points, not tracking by week. I then did a look up on the table with that person’s weekly stats. That repeated all the scores from each week to every week thereafter, making that occurrence manipulate their score every week instead of just the week

Hi, I am looking for a way to input Timecode in a Field, (ie: 12:24:32:00) (HH:MM:SS:FRAMES) The Duration type comes close but no option for double digit hours, and regular numbers don’t seem to allow colons. Anyone have any ides. Scott

Hi there, I’m trying to create a “ToDo” base with sub-tasks. I have one table with different “project” in every row, and second table with a few tasks linked to each project. Now, I want to create a rollup record to pull out the percent of the task that is already done. (like if I have 2 tasks for one project, and one is checked, so it’s 50% done…) How can I do it? Thanks!

Hello, Can you please help me : someone did something wrong in the account and delete a lot of customized fields. I see that I can restore an old version but that creates another version I think (and I am the one who can access in). But I would like to restore the latest version for everybody, is it possible ? Or do I have to open the access to the version restored to all the base ? Thanks a lot for your precious help!!! Justine

Hi everyone! I’m surprising myself by not being able to figure this out. I swear at one point or another I had been able to pre-fill an airtable form with a field that includes an emoji. For example, I want to pre-fill a single-select {Status} field in a form with a status of “ :calendar: Consult Scheduled” I’ve tried it with the actual emoji character as well as with UTF-8 (hex) encoding (which is what Airtable spits out if I wrap the emoji in the ENCODE_URL_COMPONENT() function - see below). https://airtable.com/shrIXXXXXXXXXXXXX?prefill_Status=%F0%9F%93%86%20Consult%20Scheduled https://airtable.com/shrIXXXXXXXXXXXXX?prefill_Status=📆%20Consult%20Scheduled Neither of these work. Am I barking up the wrong tree? Should I just forget about the emoji? Maybe try a different emoji? :slightly_smiling_face:

I have 10 checkboxes in my table. Each checkbox corresponds with a task that needs to be completed. I’d like to build a formal that shows an emoji each time another checkbox is checked. For example, if you’ve checked 4 boxes, there would be :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: . Or, if you’ve checked 10 boxes, there would be :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: :white_check_mark: . Thanks in advance.

I have a column of linked records. I would like to make a second column that filters those linked records based on a condition. Example: Table 1 Column A is a checkbox Table 2 Column A links to records of People that are associated with the Business Table 2 Column B should be a conditional subset of Table 2 Column A; linked records in Table 2 Column A should only appear in Table 2 Column B if the linked record has Table 1 Column A checked. Any time a checked record is added to Table 2 Column A, it should automatically appear in Table 2 Column B. Similarly, any time a record is checked or unchecked in Table 1 Column A, it should be added or removed from Table 2 Column B. From what I can tell, this is not possible in AirTable. Are there any creative ways to make it happen?

Hi there I am using airtable as OPS CRM Tool. Basically the Customer makes a Request (REQ-001) with description of the products he is looking for. Airtable then matches the description and link all PRODUCT MODELS with that Request. So on the tab REQUESTS it links all the models from the tab PRODUCT MODELS that fit that request. I would like to Batch download the Images of those products per Request (To make it easier to send to the customer, currently we are doing it manually). but there isn’t yet a built in solution for that unless you use Zapier. That said, I need create a column called “Pictures” on tab REQUESTS and link that column with the column “PICTURES” of the tab PRODUCT MODELS and get all those pictures there. So then I can use Zapier and batch download it per request. Is this possible? Thanks a lot!

Hello, I am working off the social media calendar template from Airtable and for the life of me I can’t figure out how/where to change the “content type”. I’ve tried doing it from the different views and it is just not obvious to me. Thanks heaps for your help!

Hi all, I am formatting my database to show how long a volunteer has been with us (in order to determine when to give them their 1 year of service, 2 years of service etc), however, the cut-off date each year for our volunteers is 30th April. For example, if a volunteer starts with us on 1/5/2018, at 1/5/2019 the years of service is 0, but at 1/5/2020 it will be 1 year. If a volunteer started with us on 29/4/2018, at 1/5/2019 the years of service is 1, and at 1/5/2020 it will be 2 years. I hope this makes sense! I’d love to know how to formulate this so I can get a ‘1’ or ‘2’ etc. Thanks in advance for your assistance.

Doing some simple substring removal and getting different results from the block than in JS Bin. let renderName = "MX_Topo-Chico-Agua_Mineral-Water_600ml_PET_6x"; let secondaryQuantity = "6x"; // scripting block generates an UNEXPECTED output: "MXTopo-Chico-Agua_Mineral-Water_600ml_PET" output.text( removeSubString(renderName,secondaryQuantity) ); // JS Bin, however, outputs as EXPECTED: "MX_Topo-Chico-Agua_Mineral-Water_600ml_PET_" // console.log( removeSubString(renderName,secondaryQuantity) ); function removeSubString(str,substr) { return str.replace(substr,""); } Oddly, making use of a character (rather than “”) yields proper results. renderName.replace(secondaryQuantity,"1") => "MX_Topo-Chico-Agua_Mineral-Water_600ml_PET_1"

Hello, I’m trying to compare A, B columns and fill C column with the equal values. Simple example of how it has to look like: I know that Airtable is not a spreadsheet and rows cannot be cross connected but anyway what is the best way to solve this (Links/Rollups, Zapier…?) and how to implement? I would be grateful for the help.

Hi, I need some help to do something… 1/I have a column with a price 2/ I have a column with a Single Select option, and a list of discounts (10%,15%,20%,30%) I would like to create a 3rd column, with a formula which gives me the total discounted price, based on the discount which has been selected. So if : Column B has a total of $100 Column C has 10% selected The new column D should show me $90 I don’t know how to create a formula which will calculate the discounted amount based on the selected field. I would be great to have some help on that! :slightly_smiling_face: Thanks, Sébastien

Hi airtablers I’m trying to create a business schedule table. There are ‘start time’ and ‘duration’(a lookup value from a different base) fields, and I try to formulate the ‘end time’ field by aggregating the first 2. For some reason the below formula gives the start time unchanged. DATEADD({Start time},Duration,'seconds') I tried to change the seconds to minutes and hours with same result. {Duration} also didn’t change. The formatting option “Use the same time zone (GMT) for all collaborators”, is disabled in both date fields. What am I doing wrong? Thanks

What is wrong with my nested if? It says that that It’s invalid IF( AND( {5dayswithnochange}, {issueStatus🟢or🔴or🟠}=🟢 ), "Stable ⚖", IF( AND( {5dayswithnochange}, {issueStatus🟢or🔴or🟠}=🟠 ), "Stuck 🆘", IF( AND( {5dayswithnochange}, {issueStatus🟢or🔴or🟠}=🔴 ), "Broken 🔥", "Too soon to tell ❔" ) ) )

Hi. I’m new to airtable, and fairly new to formulas. I’m trying to build a formula that looks at the part of an email domain and based on if a specific word exists or not, enter the persona into another field. Example Fields are EMAIL and PERSONA If the EMAIL domain is @usa.company.com and I’m checking if the domain contains “company” I then want to have the PERSONA be “employee”. If it does not contain “company” I want the PERSONA to be “customer” So far this is what I have IF((FIND(“company”,{Email Domain}) >=1)“Employee”, “Customer”)

Hi there I am wondering if there is a way I can have a field to auto-populate based on a previous answer. E.g. if they choose to attend EVENT 1, it will auto-populate that it is 3 days ‘Number of Days’ field, or if they choose EVENT 2, it will auto-populate that it is 5 days etc. Is there a way to do this? Thanks in advance

I need a formula to calculate ETA (more like Estimated Day of Arrival) for animal breeding purposes. I have a column with number of days bred and a column for the date checked. The average gestation period is 278 days. Is there a formula in which I could use the start date(ex: 9/11/2019), days bred (ex:84), and gestation length (ex:278) to calculate delivery day? Please and Thanks!!!

Hi all, I have a block with the following setup. For week 2 and 3 on the graph, the bars are clearly not grouping together, and even still, the group of bars in week 1 is very much left aligned. Not sure if this is relevant, but this block references a view of 9 records (filtered by if record is checkboxed) 3 of which are labelled with the same name (yellow bar), the other 6 are unique names (hence the different colours). The three types are: Single Select (Week in session) Number (Number of Rego’s) Single line text (Event name for block) Any ideas on why this the spacing on the bars is messing up? Thanks, Tom.

Hi friends, I’m new to Airtable A friend recommended this tool to me because of its adaptability to create data collections without the need for a custom tool. I have the following doubts, after I checked the airtable help tool create formula in the primary field. I took the sales crm template and just want to simplify it, only the relationships it brings are not what I need and after reviewing the help I still have problems. the idea is the following from the contact table to relate it to accounts just for one id (i don’t know if the autonumber function will work) The idea that if you can’t use autonumber, you could use email as your unique identifier. Then, the connection to the account table (which I will convert into services) will link it to the users’ email (one-to-one relationship) (as unique identifier) (the idea is that for each user you can have a one-to-many relationship; so, for each user by x amount of services). and finally, the table of opportunities (I’m going to rena

Hi! I currently use an embeded Airtable form on two sites, same form on both sites. I would like to know from which site a person filled the form. I have tried change the embed url of the embed code to an url that use prefill. From <script src="https://static.airtable.com/js/embed/embed_snippet_v1.js"></script><iframe class="airtable-embed airtable-dynamic-height" src="https://airtable.com/embed/ID?backgroundColor=green" frameborder="1" onmousewheel="" width="100%" height="6066" style="background: transparent; border: 1px solid #ccc;"></iframe> To <script src="https://static.airtable.com/js/embed/embed_snippet_v1.js"></script><iframe class="airtable-embed airtable-dynamic-height" src="https://airtable.com/embed/ID?prefill_Tips%20-%20GU%20eller%20BiU=GU?backgroundColor=green" frameborder="1" onmousewheel="" width="100%" height="6066" style="background: transparent; border: 1px solid #ccc;"></iframe> This simply results in the form not load

Hi. I have a database with veg and flowers in. For the flowers I have fields for colours, scented and evergreen. I don’t want these to appear in the veg details. Same as I don’t want ‘hungry gap’ fields with flowers (for example)… Is this possible or should I split the data? If is is, please could you give me a forumula example I could use.

Hi, I’m wondering if there’s a way to do this. I have a table with the category of a used book and the original price. I want to create a formula that calculates the selling price based on the category of the book. So it would be IF category = A then take Original Price and deduct 30% to get the selling price. I’m not sure if I can do all of this in one go with an IF formula. But maybe I can do part of it? Thanks for the help!

I have been using this formula: IF({Completed}=1,DATETIME_FORMAT(NOW(),‘M/DD/YYYY h:mm’),0) to record a date when a “Completed” check box is ticked off in another column. This worked flawlessly up until recently. For some reason, all past dates are now changing to whatever the current days date is. I have jobs months old that now say they were only completed today. Any help is appreciated. I can’t figure out what happened other than it is a new year and maybe that messed something up.