Other Questions

Hey everyone! I’m creating a column in a table where I’m concatenating a date field (formula driven), client name and default text. The result of the concatenate is adding an extra day to the formula driven date. Below is the formula and I uploaded an image of the dates reflecting the additional day. Any insight on what’s causing this? It’s so weird! Formula in the concatenate field: CONCATENATE(DATETIME_FORMAT({Monthly Rental Fee Renewal Date},‘MM-DD-YY’)," | “,{Client Name},” | ",“Rental Fee Renewal Date”) Formula in the original date field (correct): DATEADD({Staging Date},32,‘days’) Two screenshots are provided: One with the correct dates and the other with the dates that include an additional day.

How do I add risk management into a project? For example: I have a timeframe, and assign a risk, which gives me a pessimistic and optimistic view of time padded onto the start/end date. I’ve seen this in other tools, where it changes the color, so the center block is assigned, to the left is optimistic, and right is pessimistic.

In the simplest terms possible as I am not an Excel freak…when I export the grid data to a CSV or google sheet, the date and time always comes through like this 2021-09-24T07:30:00.000Z (which originally was input from Adelaiade Australia as 24/9/21 1700). How can I write a formula to seperate 2021-09-24T07:30:00.000Z into 24/09/2021 and 07:30? Any help would be great as this is a huge issue at the moment.

Hi community, I have managed to create a synced table from a Salesforce “Revenue report” that I am going to combine with data from other sources. Part of that report is the revenue number that is listed in USD, but when I look at the synced data in Airtable, it shows up in the local currency, in my case NOK. Somewhere in the sync, the data is converted through a factor or source that I have no control over to the local currency. It is also missing three digits… For example; a 10 000,00 USD deal shows up as NOK 85.00, which should be NOK 85 000,00 (but according to Nordea (A Norwegian bank) it should be NOK 83 690). As we are usually talking about our deals in USD anyway, I was wondering if there is a possibility to disable this conversion from happening?

I have always been able to expand records and print them by using Ctrl P. For the last few days, when I go to this screen, it will only give option to print the first page. The other pages do not show in the print dialog.

Not looking to move to another workspace within the same account. Had been doing collaborative work under one account but due to agreement ending need to separate existing bases under two separate Airtable accounts.

what formula can I run against a text field that will display all text characters up to a “,”. Example: TEXT1, TEXT2 Result: TEXT1

Whether I use print record or command p – and whether I use Chrome or Safari – and whether it’s to PDF, export to PDF or print to my physical printer, my expanded record print operation is only printing ONE page of the record fields. Back in June, I have an older version of my app that contains an uploaded PDF of a record, and all of the data is present and that file has all of the fields in it. Something, apparently, has changed, but I can’t figure it out. Thanks.

Hello, Question about Table, not forms. I want the select field to throw some sort of an error if another field (required) is not complete? How is that possible? Thanks

Hi My ex-VA moved some key data of mine from Excel to Airtable. I have access to the airtable table, and I need to continue to work on it. The VA left me because she caught COVID and I now cannot contact her. The table does not permit copying. How can I move the data either to my Airtable account or to an external tool? With thanks Gill

I am trying to count the number of values entered in each cell of a column, just so that I can perform certain automation. like for example, if the column name is 'Colleagues" and the first row in this column contains three names of colleagues. Then how can I automatically detect that there are 3 names/values entered in this cell?

I am using Airtable to automate my Facebook page posts. I want to use it also to post on Instagram. Is that possible? Who has experience in this?

I checked the community and the Billing FAQs and couldn’t find an answer. It’s about Referrals and credits. I’m about to upgrade to PLUS now. According to what I understood, I get a discount equivalent to the credit I have gathered up to the moment I upgrade, right? I’ve I keep getting referrals to sign up after I upgrade, do I still get credits (discounts)? How does it work if I pay annually? or do I have to get a monthly plan to get those credits discounted? Thanks!

Hi everyone! I have been using Airtable together with one collaborator for a while and reached record limit on one of my bases. Unfortunately, I think the service has a rather steep cost rise for users like me that have few basic bases with one collaborator only but who surpass a thousand records x base. I am currently paying for premium services but none of them is $20 x month with the prospect of having to upgrade to $40 sometime soon. I was thinking of excluding my collaborator from the base workplace (making him not billable) and hence cutting my costs to half. Before doing that, I need to be extra SURE that my base data will remain as it is, and if I eliminate him I won’t lose any records and changes HE had previously made to my base. Can anyone please advise me on how to proceed? Thanks so much.

Hi All, I hope someone could help me a better way of doing this. I have two tables on a base (Table 1 and Table 2). In Table 1, data is shown below: Here is what I am trying to do in Table 2: Count all similar State Country entries from table 1 Count all EMEA, APAC and AMERICAS from table 1 I tried using the Pivot Table app but the lack of exporting it to CSV is not ideal for me.

Continuing the discussion from Automated Row Duplication Based on Integer Value In Column: Hello! I’m a beginner here with coding skills that are so outdated, they might as well be hieroglyphics, but I’m looking to upgrade. I found what I thought might be a solution to my problem in the link above, but I’m getting an error message: TypeError: cakeRecordIdsAndNames.map is not a function What I actually need to do is slightly different than the original code intended, so I thought I’d reach out here to see if anyone can help. Essentially, I have a data set that is linked to some current data by the variable name. The newly integrated data has individual years as fields with the relevant value whereas the original data had a field called year and another year called value. We need the latter. So we’re trying to transpose a portion of each record.

I enter many records per day, and sometimes they are duplicated. How can I have airtable warn me about a duplicate record?

Hello, I am using the CONCATENATE formula to concatenate texts coming from different cells plus custom text. Is there a way of starting a new line after the additional text? The formula I used is CONCATENATE(“ITALIANO”,cell_n.1, “ENGLISH”,cell_n.2) and I would like to start a new line after “ITALIANO” and “ENGLISH” Thanks Giorgia

Hi, Would you please tell me if there is any way to use Airtable off-line for the bases I already have? If that is not possible, Is there a way I can Batch-CSV download all of my bases at once? Thanks for your help in advance.

Hi, I recently copied in some records that put me over the free plan limit. The warning badge tells me there is a grace period before I can no longer add any more records and will need to upgrade. I’ve searched the help docs/FAQs and this forum but I can’t find the length of that grace period anywhere. Could someone tell me how long that grace period is? Thanks in advance.

I have an Airtable database of questions and dates/times, and am running an automation that runs an Airtable script hitting a Twilio Studio Flow to send a message every hour (message is currently hardcoded.) I’d like to to just send a message from the Airtable at the date/time in the corresponding Airtable row. This is the Airtable I query the table with let queryResult = await QuestionsTable.selectRecordsAsync(); let record = queryResult.records[0]; console.log(record.getCellValueAsString("Priority")); // Query for all participants. const participants = (await ParticipantsTable.selectRecordsAsync({ sorts: [ {field: "Phone Number"} ] })).records; output.set('participants', JSON.stringify(participants)); for(const aParticipant of participants) { // Create

I just created a new workspace. It has appeared at the bottom of the list of workspaces I already have operating. Is there anyway to rearrange the order in which they appear?

Distributing a schedule with links to over 600+ people. Has any one experienced problems with 600+ folks accessing an Airtable read-only view link simultaneously?

Hi, I have a table with some data (ID number, start time, end time etc.) imported from another app and I would like to have them updated when the original data from the source change. I’ve tried Integromat Upsert record module but without success. Is there a way how to identify the record by the value in column “ID number” that is imported from the original data source and update/rewrite values in columns “start time, end time etc.”

I am trying to plan various combinations of trips, people, and room assignments. For the sake of simplicity, let’s say there are: 25 trips this year 10 two-person rooms available for each trip. 300 people who may go on these trips. Many will go on more than one trip. I have tables for people, for trips, and for rooms. How/where do I combine these so that I can plan who goes into what room on each trip?