Other Questions

Hello there! I’m working on a base for our customer support team. Each record would be a ticket. I would like to add a column where our team can browse between different templates, select one, and then edit the content for it to be personalized and relevant to the client’s specific needs. Is there a field type for that, or a turnaround I can find?

Scroll bar for horizontal is not shown. (Scroll bar for vertical is shown only.) This trouble does not happen all tables, some table happen it.

The Page Designer App has an option to ‘print all page’ in an attachment. How to make this happen? I’ve tried: The settings for the page being different sizes To print via fit, fill, stretch To have two of the same block What would help?

I am trying to use Web Clipper to create a record from a link to a TikTok post. I want the record to include the following information: #Likes = number of likes that the post has received #Comments = number of comments that the post has received #Shares = number of shares that the post has received Would someone please help me decide what to select as “Default value”? Should it be “Text content by CSS selector”? And then what is the CSS Selector for each of these requests? Here’s an example link you can inspect: https://www.tiktok.com/@gilesgillgolf/video/7026371439196507398 Thank you very much for your help!

I have spent hours rebuilding my base to support the box integration for automated file uploads. created a button for the end-user to click to open the image since the thumbnails airtable provides are completely unusable. when the end-user selects the button it asks them to log in to my box account. that’s not at all helpful. id be willing to bet not helpful to anyone attempting to use this integration. I need them to hit the button and the file open. I can’t find any permissions to change or anything that looks even close to a setting for this.

Hi Airtable community! I’m working on a script to automatically merge nearly duplicate records based on given criteria (in this case, I’m using emails), and I’ve run into a couple of problems that I can’t figure out how to solve. I can’t figure out how to get the script to apply to the actual table. It currently gives me the output as a table within the scripting app instead (see screenshot of current code output). In the table within the scripting app, it seems looks like the script is having trouble merging multiple select/attachment fields. I’m not sure if that’s just an issue within the scripting app or if it would still be reflected once the script is applied to the actual table. Script: let dataTbl = base.getTable('Duplicates test'); let dataQuery = await dataTbl.selectRecordsAsync(); let result = dataQuery.records.reduce((acc, record) => { let email = record.getCellValue('Email'); let color = record.getCellValue('Color'); let id = record.getCellValue('ID Number

I’m trying to import an Excel spreadsheet that contain totals hours that has to be formatted in [h]:ss format to display correctly. However, when I import to Airtable it displays the result as date with time “1900-01-09 15:52” which is what is showing formula bar in Excel. Apparently Excel formatting does this to be able to SUM hours?? I’ve tried all the formats in Excel and this is the only one that shows my data in Excel correctly. I’ve tried different formats in Airtable, but it still sees it as a date with time. Has anyone else experienced this and come up with a solution? Thanks

I intend to use Airtable and Zapier to automatically schedule social media tasks. Every day Zapier schedule checks a Primary key [Date] column in Airtable. If today’s date equals the date in the Airtable column then do some stuff… However, I keep receiving a “Record not found” message. I construct a date in the Zapier search field that matches the date format in Airtable. For example Zapier search value = 2019-08-05 In Airtable a primary key date column with the value 2019-08-05 I have confirmed the date format is yyyy-mm-dd in Zapier by hardcoding search string: 2019-08-05 against a text column in airtable and the format is yyyy-mm-dd. Then reviewing the successful output of the record in Zapier. I’m not sure if there is a specific date format beneath the covers I need to know about. One solution I have considered is to create a single line text column with the date converted to text and use this column as the lookup. Any ideas would be appreciated. Thanks Cam

Hey there, so I have the issue that I have users in one table (I) and referrers in another (II). Now I want to the referrer`s count (table II) of referrals to increase every time a user enters his refer-ID (Table I). From what I gather this should work through linking refer-ID in Table I to table II through “Link to another record” but it deletes all of the records existing in it so far instead. Is there no way to simply count in one table how often a respective ID from another table shows up? Thanks a lot for your help

Hello friends, I’m trying to work out if it’s possible to create unique (per record) embedded views of a table on Stacker via some formula wizardry, rather than having to manually create a filtered view for each record. To that end, I was wondering if anyone knows if it’s possible to put URL filters into the embed code for a shared view - and if so, how I would write this? Kind regards, Matt

Hello! I am trying to script that when an incoming form creates a record that the record be updated and a random team member be assigned via the select field designation. Any suggestions?

Good morning I would like to know if there is the functionality that from a table 1 of the base 1 bring me a data to the table 2 of the base 2, since the synchronization of bases is not the relationship that I expect. Best regards

When I expand a record in a table I can see that the expanded record order is the same as the table. However, if I expand that record in another table, for example when using a task system, that order is not the same. How can I switch that order to match that of the original?

Hi, I am a newbie in web dev, and I am trying to get myself familiarize with Airtable. In the Hello world tutorial (Airtable Blocks SDK), I have been trying to look for the frontend/index.js file unsuccessfully… I am working in a Linux environment but cannot figure out where the file is…is it in the node_modules/@airtable file ? Can you please help ? Many thanks in advance !

How are the fields in the expanded record ordered? Can I reorder them? (I know how to hide them, but I’d like to reorder). I’d like to order them based on how our users feel entering data makes the most sense (which is not how the base I inherited is ordered). Thanks!

Is there a log somewhere that tracks who opens a base and when?

Hello, I have table B which acts as a delivery data base showing all deliveries to have occurred. I have table A with each row representing a client and a URL field within the row for a form which populates a delivery into table B (this forms is from table B). When the form link is clicked from the client record in Table A we then need to choose what client the form is being submitted for through a linked record. This is an issue because there is room for error. Is it possible to repopulate the form with the client name from Table A - I cannot find a way so any help would be appreciated.

Hi all. I’m evaluating Airtable for use as a task and activity management solution. Part of the solution is weekly reporting on the status of ongoing projects or tasks, across a team of ~50 people. We have a Projects table which contains records for each project or task: Team members post incremental status updates against items in Projects using the Activities table: For weekly reporting purposes, I would like a Grid view grouped by Project, which shows only the most recent Activity (sample below): I have been trying to construct a Grid view of the Activities table, grouped by Project, with a formula field to identify the most recent record, against which I could filter. I have been unable to devise a method that works. In order to display as desired, it will be necessary to identify the most recent Date within each Group of Activity records. There are some problems with this - MAX() returns only numeric values as far as I can tell, and MAX(values) is only useful in a rollup fiel

I’m using airtabe with a app Nobull of Finsweet to insert the data to webflow. In this way everything goes right. But I’m stuck with rich text element. The airtable don’t support images. How can I send images inside rich text element to webflow?

I have problem with automation where a trigger is new arrived order and the values which do not show in email triggered by new order arrival. This is an example of my email when someone makes new order: As you see, there are properties which I inserted for each record, but when email is being triggered, the message does not have values, although I have done everything correctly…This is example of email received: “Hello, We have received new order from for pellet: for number of pallets to load: 0 on date: . The transporter is: and his truck registration plates are:. Buyer instructions: . Documents attached by the buyer: Delivery address is: . Telman, the price for pellet is: and amount for invoice is: 0. Please, make an invoice for order nr: 29and upload it to the system, which will then send it further to client and we will have a record about it. With kindest regards!” Can anybody tell what is wrong?

Hello Airtable community, How to use IF and ENDIF conditional statements in Sendgrid app with html ? I tried : {% if {name}== null or {name}== ‘’ %}NO NAME CONTENT{% else %}WITH NAME CONTENT{% endif %} but all the code is shown.

I’m brand new to Airtable and use a Macbook. I somehow moved a column over to the Primary position when I was trying to swipe between windows and now I can’t change the Primary column back. Any suggestions as to how to reset the Primary column. I have tried to copy the column and delete the existing primary column, but the delete option is greyed out. Thanks in advance!

Let’s say I have a list of Artist / Track / Link and I want to store it in Airtable. I know that would be easy with a 3 column table in some base. But let’s say I wanted to add notes to some of the rows. For example, for some rows I might want to add extra information about the track. This would be for some rows but not all rows. I know I could use a table with 4 columns, like this: Track | Artist | Link | Notes But if most of the Notes fields are going to be empty that seems like an odd/inefficient way to do this. What is the best way to do this? Thanks much.

I have 2 tables, both with email addresses. In Table #1, I would like to be able to show (e.g. a checkbox) if an email address appears in Table #2. Is this possible?

Hi, I’ve been stuck with this for almost 2 days now and have exhausted all experimentation and research. Looking for any help I can get. I have a field in Airtable called @EventRegistration, which is a linked reference field but allows linking to multiple records from another table. In Integromat I’m using the Update record module for Airtable and what I want to do is that each time a new form response is submitted, I want to add an item , i.e. append a new linked reference item. Unfortunately, I can’t seem to find a way to do this. With each run, Integromat simply updates the original linked record when instead I want to keep appending to this multi-reference linked field dynamically. I cannot predict how many items will be added. I just want items to be appended when my scenario is triggered but instead Integromat overwrites this field with the latest value from the current run. How can I have Integromat append to my multi-reference linked field instead of overwriting it? Thanks in