Solved

Hi everyone, I would like count the number of records form another table. For example, I have created a table with all the payments that the company receives, and they are linked to the customer master record. But I would like to add a control in the customer table of the number of payments made by this customer (the number of records, because a payment is represented by a line). Is there a way to search a second table and count the number of records for a client? Many thanks in advance for your help. Have a very nice day. Alexia

I have a formula I can’t figure out. My column that I want as a formula is called “Forecasted SCIP Received” To calculate this date, I need to use another column called “Actual Site Walk Date” plus a “Duration” column. However, if “Actual Site Walk Date” is empty, I need it to use “Forecasted Site Walk Date” instead, so: If the “Actual Site Walk Date” is not Empty, then “Actual Site Walk Date” + “Duration”. But if Actual Site Walk Date is empty, then “Forecasted Site Walk Date” + “Duration” How do I write this?

Hi everyone, I’m new to this. I have created a table to collect student grades. I collect the data on a form and populate the Student and Score fields by use of a form. Thus, I have many different names in my Student field. When I filter the names, I easily separate out any specific student’s scores over the previous 20 tests. But, I cannot figure out how to AVERAGE these scores for each student. Can this be done, or is my data collection method fundamentally flawed and I should start over again? Happily accept everything but blows. :slightly_smiling_face:

I have 2 different lookup fields: Release1 = lookup individual item release date from another table ReleaseMulti = rollup multiple items release date based on condition (if its a multi-item) using MIN(Values) I then have a formula field: RELEASE = IF(Release1="", ReleaseMulti, Release1) Without grouping, this RELEASE field appears correct… for example showing 9/30/2020 in several records. However… if I group by RELEASE, I find that it will split into different groups if the 9/30/2020 is from Release1 vs ReleaseMulti in a different group This is very problematic. I know ReleaseMulti is an array value, and on a similar text based field I used &’’ trick I read on these boards which solved that issue. But in this date field adding the &’’ to the end of ReleaseMulti in my formula does not work. I also tried many combinations of arrayflatten, arraycompact, date parse, datetimeformat, etc… to no avail Can anyone advise how to get a single date from the ReleaseMulti array and conve

I’m trying to make a script to make product planning easier in conjunction with the gantt chart. I have four fields. startDate (date) endDate (formular) depended (link field to same table) lookUp (looks up the endDate via the depended link field) In the first record I put I set a startDate and endDate gets automatically calculated based on various parameters. in the second record link to to the first record and and the look up field looks up the above endDate, which my script then passes into the startDate and then it stops. My problem is that I want to have a bunch of records stacked on top of each other. Set the dependency field (which job it should follow) and press a button and then it’ll pass the lookUp endates into every start date, but because the lookUp takes a little time to update, it stops after the the first date. Is there away to make kind of make if loop over itself again and again until all dates with dependencies are filled? const luPlanRecords = await prodView.select

Hi everybody, I am new to using Airtable. I am sure that there is a formula for this but I can’t seem to find it or I don’t write it in a correct way. With a API service of a third party software I pull data from my Airtable. This data is dynamically filtered by using filterByFormula. The data I need is in the column called “groupcode” and has numeric values varying from 100 and 900. These numbers stand for product categories. Normally if I need products from the category with the number 212 I use the following formula. {groupcode"} =“212” But now I need products from category 212 and 268. Is there a way I can display only the records of two different specifc values ? Any suggestions or tips are appreciated! Thank you in advance!

Just wondered has anyone used Airtable to Organise their company manual? I am quite new to Airtable and getting a little over-excited - at the moment our company manual drives me crazy as it frequently needs updating (or at least small sections do) just wondered if anyone else had popped there’s into here and if so what it looked like and how successful its been

I’m searching for the occurrence of a specific character in a text field with SEARCH but it doesn’t return any answer, can you help?

Is there a way I can add the same record twice in a linked record field? I’m building a product sales database. When I have 2 of the same item in a customer order, I can’t figure out how to add the same item twice in the order record. I’d rather not have to track each order item individually on it’s own row because it becomes difficult to calculate the shipping costs for each item in the same order. Thanks in advance for any help!

Hello! I’m new to Airtable and am loving it so far. I’m creating a database for online resources, aiming to be shared public, read-only. But I’d like to know if it’s possible to have anyone create their own Personal Views on it? Mainly for Galleries Is it doable, or does it require further steps, such as anyone who visits has to become a collaborator?

I am having trouble with a formula. I need to bring back an exact minute time but cannot figure out how to make it read the minutes in this equation. Can someone help?

Hey all, I’ve been trying to work this out on my own but it’s providing super difficult. I have a birthdate field and I want to find out the age. I am using DATETIME_DIFF(NOW(), Birthday, ‘years’) & ’ years ’ and I see the age however those that haven’t filled in the birthday field say Nan. I would love some help. Thank you

Hi! We made an Airtable form and we have a custom domain that we want to mask the form’s URL. We can get our URL to redirect, but we get an error if we try to actually mask the Airtable URL. Does Airtable block this? Our domain name provider says it is on Airtable’s side.

This is the last post I found in the “community” on this topic with any clear response, as of July 2019. Is this still the status, or has there been an update? Replay from Cameron at Airtable: "Hi Gary, You can white label forms on[Airtable Pro but it isn’t currently possible to white label Airtable or add your own custom branding in any other way. I hope that helps! Cameron

I have a TablePickerSynced that I’d like to filter the options for. I’ve got the element conditionally disabled based on the presence of a selection in another TablePickerSynced: <FormField label="Which table holds the Events/Bookings?"> <TablePickerSynced globalConfigKey={GlobalConfigKeys.APPOINTMENTS_TABLE_ID} onChange={() => apptCheckTablesAreNotSame()} size="large" maxWidth="350px" disabled={!props.globalConfig.get(GlobalConfigKeys.PEOPLE_TABLE_ID)} /> </FormField> …but I’d also like the Tables available to be picked in this second TablePickerSynced to be filtered to only include those Tables to which the table selected in the first TablePickerSynced (props.globalConfig.get(GlobalConfigKeys.PEOPLE_TABLE_ID)) has a Linked Record relationship. Is this possible? I don’t see anything in the documentation that would indicate that it is, but I know the FieldPicker can at least disable certain options within the picker

How do I delete “unnamed record” across the gallery view or how do I fill it in? I can’t figure out either.

I am attempting to calculate asset depreciation using Airtable. I am calculating using the following Fields: Purchase Date: Date field Unrecovered Basis 1: A formula which is returning a currency value 1 Year (from Depreciation Conventions): This is a lookup to another table which has the 1 year depreciation amount. This is a numerical value (decimal) I have reduced the formula I am attempting to use down to it’s simplest form. There will be more switch states, but it doesn’t even work with the 1, so I didn’t want to confuse matters by adding more. The formula returns a result just fine, but I am unable to format it as a number (currency) and thus, am unable to use the value in future formulas. The Formula is this: SWITCH(DATETIME_FORMAT({Purchase Date}, ‘YYYY’) - 2015,1,{Unrecovered Basis 1}*{1 Year (from Depreciation Conventions)},BLANK()) When attempting to format the field, it states “Your result type is not a number or a date. Formatting options are currently only available if

Hello, I am a new user- I created an Airtable base that is updated via Zapier from a Google sheet. The records seem to be populating from the Google sheet correctly, but when I try to Group by Client name, not all the records are grouped. I will have some records with the same name in it’s own group. This has happened a number of times so manually dragging those records to the other grouped records of the same Client name has become cumbersome. Has anyone else experienced this and know of a fix or what I may possibly be doing wrong? Thanks in advance for any help on this topic.

I’m using the CollaboratorToken component: Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. but getting an issue. This works: <React.Fragment> {base.activeCollaborators.map(choice => ( <div> <p>{choice.id}</p> <p>{choice.name}</p> <p>{choice.email}</p> </div> ))} </React.Fragment> but the code in the docs is giving me an error: <React.Fragment> {base.activeCollaborators.map(choice => ( <CollaboratorToken key={choice.id} choice={choice} marginRight={1} /> ))} </React.Fragment> Any pointers on this one? I’m importing CollaboratorToken, useBase so think all is good there. Thanks!

I published my airtable grid on my website but want to block viewers from being able to download the grid. How do I do this???

Am trying to export or call two functions Eg. (teachers.js and student.js) that are link up to index.js but it throws error initializeBlock should only be called once. If i tried to call the both at index.js as per below, it will not work. initializeBlock(() => {<Teachers />; <Students />}); How do I solve this issue. student.js import {initializeBlock, useBase, useRecords, createRecordAsync, updateRecordAsync, updateRecordsAsync, table, useRecordIds} from '@airtable/blocks/ui'; import React, { Component } from "react"; import {base} from '@airtable/blocks'; function Students (){ const base = useBase(); const tab = base.getTableByNameIfExists('students_table'); const records = useRecords(tab); return ( <ul> <h1>Welcome to Students Records</h1> <br /> {records.map(record => { return <li key={record.id}>{record.id}</li> })} </ul> ); } //initializeBl

I’m doing a simple budget with Airtable, and when I had done it previously there had been a summary bar at the bottom that summarized the currency fields. Now I don’t see any such thing. Is that only part of Pro now? Did they take it away entirely? Or do you need to manually add in the summary bar?

Hi, Airtable newbie here. We are trying to setup a table that calculates farm type based on size of farm. The result we are looking for is this: Acres…Farm Type Empty…Unknown 0.0…Landless 0.1-5.0…Small 5.1-20.0…Medium 20.1+…Large Trying to use this formula: IF(Acres = "", "Unknown", IF(Acres >= 20.1, "Large", IF(Acres >= 5.1, "Medium", IF(Acres >= 0.1, "Small", IF(Acres >= 0.0, "Landless", "Unknown" ))))) This is causing a conflict between Unknown and Landless. Any idea why and how to fix this? Please help. Thanks in advance.

My reactjs application is running successfully. now I need to import css file (styles.css) when I run the code after adding import "./styles.css"; it displays error unexpected token . import {initializeBlock, Input, useBase, useRecords} from '@airtable/blocks/ui'; import React, { Component, useState } from "react"; import ReactDOM from 'react-dom'; import "./styles.css"; class Access extends React.Component { //content goes here } I

I have a table with {date_approved} column, now I want to summarize the count for this per week. For example: {date_approved} | {count} 06/01/2020 | 5 06/02/2020 | 5 06/03/2020 | 5 06/04/2020 | 5 06/05/2020 | 5 06/06/2020 | 5 06/07/2020 | 5 06/08/2020 | 5 06/09/2020 | 5 Let’s say 06/01/2020 and 06/08/2020 is Monday. 06/07/2020 is Sunday. Total count: 35 (Monday to Sunday) At present, this block is only summarizing the count per week, Monday to Sunday. But I it to count/group from Friday to Thursday by default. Is this possible? If not, what should I do to get the same effect? I just want to get a summary of {count} each custom week range {date_approved}. Thanks!