Solved

Hi everyone! I am having a hard time with some formulas due type of cells and blank cells. Hope you can help me. This is the Nested IF I wrote: IF( Cuota=PagoEnero, “Pagado”,IF(PagoEnero=BLANK(),“No” , IF(PagoEnero=0,Cuota-PagoEnero ,IF(Cuota-PagoEnero>0, Cuota-PagoEnero)))) The formula returns the same result if the cell is blank or is =0. I think this is because the statement will always be true in the second one but i dont know how to fix it My second issue is that, I do the same formula multiple times (Enero, Febrero…) and i need to summarize only the results that returns a number (not text) and make a sum For example: Enero=0, Febrero=No, Marzo= , … Returns: Enero CONCATENATE(IF(Enero=BLANK(), “”, IF(Enero=0, “Enero”, IF(Enero>0, “Pagado”))),IF(Febrero>0,"",“Febrero”)…and so on) I think due the column “Enero” is a formula does not recognize the result as a number, this is not working. I have tried to change text to number and it fixed but brings other problems. Could anyo

This works one row at a time. Would love to be able to do this to multiple records. I need to copy several rows that include one column that is a reference the RECORD_ID() for a given table and another cell that has one or more linked records from another table. The new table has a linked column to the table referenced in the RECORD_ID() above and a column that references the same linked field. Again, if I create a record and paste into it, it works great. The Record_ID reference connects to the original table we are pulling data from. Also, if I create 5 rows (as a for instance), I can paste 5 rows I copy from the original table. QUESTION: Is there any way to copy 40 rows of these two fields and paste them into the other table without first creating the rows in question as blank records? Basically, a paste/append. I hope this makes sense. Thanks for any insight.

Hi friends, I’m hoping someone can help troubleshoot why a conditional rollup is returning a zero “0” value. Table 1 has a list of vehicles. Table 2 records all certification renewals. There’s about a dozen different certifications required per vehicle, with varying expiry dates. I have a linked field in Table 2 connecting each certification expiry with a specific vehicle in Table 1. I have a helper column in Table 2 that filters the date for a specific certification type. I’m trying to run a Conditional Rollup in Table 1, that returns the MAX(values) from the helper column in Table 2. But it’s returning a zero “0” figure. Any pointers would be appreciated. :winking_face:

Hi, I’d like to remove the limit of 100 Rows on pagination in PowerBI. Can anybody please provide some code as I’m not good at code. Here is my current code: let Source = Json.Document(Web.Contents("https://api.airtable.com/v0/appqRdDk5cCOPccJ5/Third Inning Report?api_key=my_key_here")), #"Converted to Table" = Record.ToTable(Source), Value = #"Converted to Table"{0}[Value], #"Converted to Table1" = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table1", "Column1", {"id", "fields", "createdTime"}, {"Column1.id", "Column1.fields", "Column1.createdTime"}), #"Expanded Column1.fields" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1.fields", {"OpportunityID", "New Category", "Anticipated Timing", "Country", "Existing LP", "Client", "Reporting Name", "Low", "High", "Expected", "Comment", "Account", "BAI Status", "Status"}, {"Column1.fields.OpportunityID", "Column1.fields.New Category", "C

Hello Airtablers, I need to automate links between a table full of User records, including a unique user ID field, and a table full of Invoice records, each Invoice also includes a user ID field. New Invoice records get created more frequently than User records. For each new Invoice record that gets written to my Invoices table, I want Airtable to recognise the User ID and use this to auto-link to the corresponding User. A single User will have multiple Invoices, and each Invoice uniquely belongs to a single user. I need to be able to open a User record and have access to all the invoices that correspond to that user, and perform rollup calcs etc on the various fields in the Invoice records. I can do all this by manually linking each new Invoice record to a User record, but have not figured out how to automate this.

Hi, Quick question, can’t seem to see it in documentation. If I have a base, on a Pro account, and I want to invite a collaborator, that also has a pro account, do I have to pay for them to collaborate too? Cheers Jason

How can I create a “What’s New” view similar to Airtable’s "What’s New page? I tried to do it using a Record List but don’t see how it can be embedded and the Grid does not support the same formatting or popup functionality. Didn’t see any examples in any of the Forum posts. Any ideas? Thanks. Jens

I am looking to create a multi user membership management system. Does Airtable allows for audit trail of users, so that we may track which user alters a record?

I have a PLACES table with an address (string) field I have a GPS table with an address (string) field and a Link to PLACE How can I set the PLACE fileld according to the address ? I can do it in NodeJS Caching all the PLACES Then finding the matching address But would be better to use a kind of “reverse rollup”

This formula from the blog produces the result with at time: 9/30/19 12;00am What part of the formula needs to change to eliminate the time? DATETIME_PARSE(DATETIME_FORMAT({Period},‘MM/DD’)&"/"&YEAR(NOW())) Thank You

Hi all, I am trying to create a weighted pipeline in one of my bases and getting stuck on the formulas. I have a single select field Opportunity Status and I’ve created a nested IF formula to return a value based on each status: IF({Opportunity Status}=“Committed”,“1”,IF({Opportunity Status}=“Convincing”,".8",IF({Opportunity Status}=“Cultivating”,".4",IF({Opportunity Status}=“Engaging”,".1",IF({Opportunity Status}=“Received in Full”,“1”,IF({Opportunity Status}=“Received in Part”,“1”,“0”)))))) The formula itself works, but it’s not recognizing the values as numbers and the format option won’t let me change it. I need the field to be recognized as numbers so that I can make a second formula field that multiplies the Opportunity Amount by the result returned by the first field to show the weighted value (e.g., $100,000 at Opportunity Stage=Convincing should be multiplied by .8 and return $80,000.) Does anyone know how to do this or another work around?

Hi, Hope someone can help. My head is bursting. I have created a childcare system in Airtable. Everything was based on hourly costs so all calculations from payments were easy, number of hrs * hourly rate. I’m now told that there is a monthly deduction. Other than using grouping to show monthly costs, I have no way of adding “Monthly” as everything is a rolling total of hrs How can I do this ? is it possible to modify the SUM on the grouping to add field ? Any help appreciated Jason

I have a table where we have products defined something like: Product name | Client | Other product info In another table, we have the columns: Products selected | Client You select multiple products for Products selected and the Client column is a lookup. However, the same client shows up multiple times in the Client field if more than one of their products is selected. Is there a way to show any given client a single time in the Client field? I had hoped that using a new field, Client unique with the ARRAYUNIQUE function would do it. But ARRAYUNIQUE only seems to work on numeric arrays. Any idea how to accomplish this? Thanks.

I have 2 tables: Table 1 is a list of every country in the world Table 2 is every possible 3 letter combination of the English alphabet (all 3 character strings) My goal is to see how many countries contain each 3-letter string. I linked each of the 3-letter strings to every country, then performed an ARRAYJOIN(): UPPER(ARRAYJOIN(Countries)) Then I used FIND() to find all occurances of the Permutation in the Array: FIND(Permutation,{Country Array}) The FIND field is returning way more results than expected. For example, for the Permutation “ABO” is returning 722 results. It should be returning 1 results for GABON Can Airtable do this? https://airtable.com/shrElPYYr5XW1Y0i2

Hi- I am moving an application from Fieldbook to Airtable, FB has lovely formulas that allow the user to look thru a link to a table and perform any formula on that table, similar to rollups but with more functionality. Recreating my systems in airtable, i am stuck on one i can’t work out. i have a table of entries called 'table2 and want to find ‘price’ in the last entry. In fieldbook it’s simple: last(table2.price) I am not finding any equivalent in Airtable. there are various other data points in the row on table2, including a sequential integer field called ‘ownership Number’ where the ‘last’ would also be the ‘max’ however i am unable to get a formula to work in a rollup that says 'lookup ‘price’ on ‘table 2’ for the row with the max ‘ownership number’ Any suggestions?

Hi, dear pros, can I ask, anyway that I can realize this: table A: tasks table B: doctors if a linked filed from table B writes on table A: for instance: Dr. Brown, i want to have another field on table A can show something like “Health” not sure how to write formula on something linked to another table

The batch update block does not seem to allow selection of image fields for update. I plan to import 2000 records into a table. THEN I need to import 2000 images whose names match via the record ID as primary photos. THEN I need to import 2000 more images whose names match via the record ID as secondary photos. etc Cannot see where this may be possible in AirTable

Question: I have a collaborator field with numerous collaborators per record, and I was hoping to add a field that would add up how many collaborators there are listed in that record. How would I do this? Thank you!

I’m absolutely brand new to this platform. I have a largish Excel spreadsheet of donations by donor versus time. Does your software allow queries (similar SQL) of these data? Thanks, Mike

Is it possible to hide fields in a view on the mobile app? I’ve searched the forums and couldn’t find anything. I’ve also dug through help files and nothing mentioning that you can’t do it. Am I just being dense, or is this not something you can do on the mobile version of the app? Thanks!

Hello, I would like to send daily recurring reminder emails to my team members. I would like the email to be formatted to include the task due and also include specific fields that I have created including multiple select fields and due date. For example, within a table, “tasks”, I have a view which is filtered to include a single team members tasks grouped by due date and a multiple select field identifying the “importance” of a task, either “low, moderate, and high”. I have a formula column which prints the text “send reminder” if the due date field is today’s date: “IF({Due Date}=TODAY(), “send reminder”, “”)” I have set up a Zapier trigger using the “scheduler” zap, which is scheduled to trigger every morning at 5am. Next, I set up a Airtable action, “find record”, to search for the value of “send reminder” in the table. I then set up an action for gmail to send an email to the team member. I want to format the contents of the e-mail to contain: The name of the tasks due today, alo

Hello, I am trying forms in Airtable… I want my user to select number of his brothers from a dropdown list of 5 numbers: 0, 1, 2, 3, 4. If he/she chooses 4, then display 4 groups of 7 text inputs like name, last name, occupation, dob, email, business, mobile number. same for 0,1,2,3. if 0, then jump to next dropdown of sisters and do same process & next children. How should I do this? Thanks for any help in advance :slightly_smiling_face: Kartik

I’m looking to estimate a person’s retirement date based on their career start date, this would be using the assumption that they would work 35 years following their first job.

I’m looking at removing all collaborators from a cell. I have attempted to send different variations of data and always receive 422. I’ve tried to: Update the field with an empty string: ‘’ Update the field with an empty json: {} Update the field with an empty record: {‘id’ : ‘’ } I can always update it correctly with {‘id’ : ‘usrXXXXXXXXXX’} I know I can send a valid request but I can’t send a valid request to clear the cell. The cell is clearable in Airtable on the web interface, so I believe it can be done but the API documentation doesn’t say how to clear a cell with PATCH. Using PUT seems drastic to update a single cell by sending all the other data except that cells data. For reference, most field types are an empty string apart from the checkbox which is the string “false”.

I am trying to write a function that allows me to add a set of numbers if a specific criteria has been met. EX: SUM (IF {Category 1} = “widget”, value {Cost 1})+(IF{Category 2} = “widget”, value {Cost 2})+(IF{Category 3} = “widget”, value {Cost 3})+(IF{Category 4} = “widget”, value {Cost 4}) (I’m not even sure if an IF function can be used this way.) I also don’t know if I should be using a rollup table or something else, given that this data would be on a separate sheet. Any help is appreciated. Thank you.