Other Questions

I’m trying to write formula for a field that would check the {CHECKBOX} field for a check (=1), and also check another {FINAL AMOUNT} field for a range, to then return a corresponding value. If the {CHECKBOX} is empty (=0), I’d like the field to just return a “0”. I’ve tried tons of different ways to nest IF and AND statements, and the only formula I tried that will not trigger a syntax error will not display the values if both the checkbox and range criteria are met: IF(AND({CHECKBOX}=1,{FINAL AMOUNT}<20000,500,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}>=20000,{FINAL AMOUNT}<40000,750,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}>=40000,1000)))))) If I try to add one more IF statement (either at the beginning or the end) to yield the “0” if {CHECKBOX}=0, Airtable tells me it’s invalid: IF({CHECKBOX}=0,0,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}<20000,500,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}>=20000,{FINAL AMOUNT}<40000,750,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}>=

Hi everyone I currently have a table of PROJECTS (100s) and a table of RESPONDENTS (1000s). Could anyone advise how I could easily assign a batch of filtered RESPONDENTS (let’s say I filter to about 1000) to a one (or more) selected project/s from my PROJECT table? What’s the most efficient way of doing this? Any advice would be greatly appreciated. Thank you Stephen

I would like the different Collaborators to be able to have a view where they see only their records when they login to Airtable. Currently the only way to do this would be to create a view for each user with a filter on Collaborator field. Or is there a better way to do this, say filter for Collaborator to be the “Signed In User” Ruchika

I love Airtable and I love to use it for all the things but I really wish in there kanban mode you could just type and hit return in the view instead of it opening the field for each record! I do this in Asana but I don’t want everything in different places :weary:

What is the syntax for an IF statement that only generates output if two conditions, in two fields, are met? Thanks for your help!

I am having trouble sorting a list of records in chronological order by date using a field that I have formatted with a formula that calculates the day of the week, month, day of month. The sort is defaulting to alphabetical. The formula I’m using is CONCATENATE({Start Day},", ",{Start Date}) Start Day Formula is: DATETIME_FORMAT({Start Date & TIme},‘dddd’) Start Date formula is: DATETIME_FORMAT({Start Date & TIme},‘ll’) I’m running into an issue as I go from month to month that aren’t in alpha order (sept to oct for example is being listed with oct first. I feel that if I change the formula I sort by to a DATETIME_FORMAT then this could be fixed but I can’t figure it out. Any help or direction would be greatly appreciated!! Thanks!!

I’m building a base to track contributions and multi-year pledges to a charity. Am wrestling with how to apply gifts against a specific person’s pledge when someone has more than one pledge. Example: Bob Smith pledges $100,000 to a building project for a new HQ, then 6 months later makes another pledge of $250,000 to endow scholarships. Each pledge might have a separate payment schedule (e.g., $33,333k/year for 3 years … or $25k/quarter for 2.5 years, and I need to be able to track payments made against either pledge so I can track the balance. Have someone using a Form to enter pledges or payments (separate form for each). Currently have pledges and payments (whether the payment is a one-time contribution or payment on an existing pledge) together in 1 table. Do I need distinct tables for pledges and payments? Other suggestions? Thanks …

Hello I have a long list of records that I have grouped by 2 fields (first by Week # single select and then by Start Day and Date Formula). I then want to sort so that all the records are in chronological order (sorted by Week #, then Start Day and Date Formula in chronological order) I’m finding that the sort function is being applied within the smallest group (Start Day and Date Formula) in alpha order. I also am finding I can’t sort by a hidden field that is not a part of the grouped fields (for instance the original start time field). The big issue occurs when a week runs over two months that are not in alpha order (Week 39 spans September and October). Is there a workaround here? Appreciate any help or insight. mel

I have a Search block that’s set to check three tables in our base. Two are formatted similarly (both are a kind of inventory), while the third tracks duplicates between the other two. What determines which fields (other than the name) show up in these preview cards in the search block when multiple tables are being queried? The fields shown do not match the order of the fields in the tables queried, and they’re not in alphabetical order. I’ve already found this question and it does not address my issue: Fields showing in preview of reco

I’m running into this exact issue: Google Sheets import not working I’ve tried the solution of deleting all but the primary sheet and that did not solve it. I have logged in and out, and no one is touching the sheet or base (no one else even has access). Any tips?

Hi! Every time I copy multiple cells from an xlsx file to Airtable ‘Long text’ column, the text formatting gets ruined, division by paragraphs vanishes. It looks like a single paragraph. I was wondering, if there is a way to avoid this? Thank you in advance for any tips!

Hi! I am building a base where I need the total value of one of my columns (the SUM of all the numbers shown there) but as a summary of the whole table. I tried to do rollup but it works in rows and not columns. Is that option available? I know that at the end of the table it can be shown the sum of all the values, but I need to sync two different tables. Hope I am explaining myself. Thanks!!

Hi all, I read a number of articles on the forum regarding the linking of fields across tables, but cannot figure out how to handle the following situation efficiently. I have an Excel file containing data collected over a long period of time, about the various components and subcomponents found in a given system. After importing the file into Airtable, I have two tables: Table 1 lists all components in the system Table 2 lists all subcomponents in the system and shows what component they’re associated with. Note that each component can be associated with 0, 1, or multiple subcomponents. Subcomponents are associated with only one component. I’m trying to add a “Subcomponents” column in Table 1 where, for each component, the cell would show all the associated subcomponents (if any). At this point, I’ve added a “Subcomponents” column in Table 1 and linked it to Table 2. However, I’d like for Airtable to automatical

Hi! I am working on a PTO log for my employees. I have it set up with 3 tables. PTO - Its the main table with their name, hire date, days earned, current balance, etc… Requests - This is were employees submit a PTO request using a form Reviewed - This is were the supervisors review the request using a form. This then allows them to add in the “Request ID” (last name - unique number) and to link the request they are viewing (seems a bit redundant but I am trying to see which is going to be easiest) ACTUAL PROBLEM PART. I want the reviewed record in the REVIEWED table to be automatically linked to the PTO table when the REVIEWED record is created. I did get it to update the PTO table with the linked REVIEWED record. However, It is removing the previously linked record. I need it to update the linked field with removing the the previous linked records. I am using the linked records to add the “day

pro plan won’t accept more than 25000 records

How can i configure Date entry to capture date entry automatically to date the form is submitted, if possible along with time.

I have two tables linked and somehow it produced duplicated new records such that Table A should just link to Table B “SKU001”, but it creates multiple Table B records “SKU001” “SKU001”. I then try to combine these duplicated records by copy-paste duplicated “SKU001” links into one, but it it didn’t work… This means now I have 1500+ Table A missing the link. How can I get these missing link Table A records without go through each record manually link them back? These Table A records all have different SKUs to link to. Is there a way to get all the “Last Edit Value” in Table A, so I can just copy paste the latest edit back to the link? All records show I did remove SKU, I hope there is a way to read that value so I can copy-paste it in bulk. Thanks,

I am working on an interview scheduler airtable base. I have an availability table which is linked to a scheduled times table. Dates in the availability table show in local time, but once a time slot is entered or selected into the scheduled times table it does not show up in local time. How can I make it do so? Screenshots are attached.

Hi All, New user here. I would like to mass-populate a column after I have filtered to only the blank rows/records. When I filter to view only the blank cells and populate the first cell, it is removed from my view because it no longer is blank. Is there a way to filter to all of the blank rows and mass-populate these cells with the same value?

I was wondering if there was a way to compare data with the chart app, between tables. I have a table that is '20, '21, and will begin a '22 one shortly. I would like to compare changes from year to year via charts. Is there a way to do this? or do I have to create 1 master table, give everything an identifier in a year field and then build the chart that way?

I just connected Vision App to my Base and have a few questions: First, my Use Case: We are entering Orders data from a receipt into Airtable, so I thought and searched if there was a way to maybe scan the Receipt and extract the text on the Receipt. Questions: I have set a field as the Attachment field, but everytime I add a new Record and add a new scanned Receipt image file to the Attachment field, and then click “Analyze” in the app window, it says it will bulk extract all the attachment field files of all Records, including existing Record ones I have already added earlier and already “Analysed”. It says it will cost x credits, which includes all the files of the existing Records as well. Is there a way to only click to Analyse new Records that have been added? Or another way to setup so we can upload a few scanned Order files and extract just those, each time? I am using Text extract, and all the text is saved into a sing

Hi, I’m trying to figure out if there are any significant differences between using the downloadable desktop app (for Windows) and just using Airtable in a browser (such as Chrome) and any advantages to using one over the other? So far (admittedly with only a little testing), I haven’t really found any except for having menu command available in the desktop app. I did see the web page, What are the differences between the desktop and mobile versions of Airtable? It seems there that “mobile” is synonymous with “browser,” but maybe not? Thanks, Stephen

Hi guys, I would like to my collaborators just see their assigned task. I dont want them to see task from other members in the same table. Is that possible?

Hi Team, I am looking to integrate airtable with process street, can you please help me with that?

I would appreciate it if anyone could help with the following scenario I have 2 tables, Table A is client lead table, Table B captures data from a form. when a clients answers are captured in Table B I need those answers to be updated for that client in Table A. thanks in advance