Other Questions

Hi all, First of all, I’m discovering Vega lite and I have to say that I love it ! I’m trying to do a scatter plot, with (1) the dots being proportional to a value and (2) a text label next to each dot. I’m actually able to do each of these in isolation but when I try to do both at the same time, the labels inherit from the dot size. Is there a way to achieve this ? Here is the configuration I’m using : { “$schema”: “https://vega.github.io/schema/vega-lite/v4.json”, “title”: “Dashboard”, “width”: “container”, “height”: “container”, “layer”: [ { “mark”: “circle” }, { "mark": { "type": "text", "align": "left", "baseline": "middle", "dx": 3 }, "encoding": { "text": { "field": "text_value", "type": "nominal" } } } ], “encoding”: { “x”: { “field”: “x_value”, “type”: “nominal” }, “y”: { “field”: “y_value”, “type”: “quantitative” }, “color”: { “field”: “stage”, “type”: “nominal” } ,“size”: { “field”: “size”, “type”: “quantitative” } } }

Hey everyone, I’d like to merge some records and retain anything linked. I have a table with companies and a table with agents. Some of the companies have more than one entry due to spelling errors or variances in formatting. I’d like to combine these records but retain the agents that are linked, and any other linked records or information. For example, in my companies table, I have “Clarence” and “Clarance”. They are both the same company and should be one record. A new record was created due to a spelling error. These companies have different agents linked to them, but I’d like them all to fall under the same company name in one record. Is this possible? Any help would be much appreciated. I’ve looking in other threads and online but haven’t been able to find a definitive answer. Thank you

Hi, I’ve been using Airtable for just over a month now. Now, I need to display the corresponding "Product Sell Name " so that it can be used in Page designer to create an invoice. (image attached below) The problem is: "Product Sell Name " is getting displayed against the column “line Items 2” but they are separated by commas. I can’t use them in the “page designer app” to create an invoice. Can you help me show, how to get the products name so that it can be used in creating an invoice? Regards, Chak

Hello, I’m trying to order by Pivot Table columns by months throughout multiple years while displaying just the month and year for example “January 2020, March 2021, April 2023”. The problem is that the only way it’ll sort properly is if I append the year and month to the front of it like “2020-01”, “2021-02”, “2023-04”. It makes it much less nice to read: The part highlighted in red is necessary for the sorting to work properly. The part highlighted in green is ideally the only part I would like to show. Is this at all possible currently?

I’ve got a button that runs a script that send a webhook to integromat and it works great but of course isnt allowed on IOS. Is there a workaround for the people in my group that only use their phones to interact with airtable? I was using a checkbox but that leaves integromat running every 10mins.

I just read this Contacting Airtable Support about bugs Says to use the In-App to contact Support. SO — how do we contact support when we’re getting this

Hello all! I am working out on building a base for my analytical laboratory. I have say, 5 experiments producing 20 samples a day. Each sample might need to be run on many tools. Let’s say a GCMS, a NMR, FTIR (science stuff) I am trying to figure out how to best handle this. If this were a simple “create sample”->“run sample”->“Done” scenario, I wouldn’t be posting here, but it is more complex. I want the machine operator at the GCMS to be able to sit down each day, and see what items are in the to-do list for that tool, and I want that person to be able to mark as in-progress or complete. Same thing for all other operators. I am using a table for tools, and a table for samples. Each sample has a multilinked record to tools for to-do. Then, there is a multi-linked record for in-process, as well as complete. This all works, but it can be a bit clunky. The tool operator has to manually delete the “to-do” tool link, then create the “in progress” tool link. I know I might be overthi

I’m looking for a way to have the gallery view only show the next 4 events coming up. I know I can filter by limiting the date but the event intervals (#s of days between things) are inconsistent so I am looking for a way to have it only show the next 4 events no matter when they are happening but still be sorted by the date. Then when one event date passes it drops off and the next event shows. Any ideas??

I have had credits through 2 e mail addresses (I changed from a gmail account to a business email) and I want to use them and do more here, but not through 2 separate accounts. Can anybody help or advise please?

I have a base with several tables of school programs that students can sign up for through a Jotform. I do not want to merge these tables into one because each program has various data/fields that are unique to it. However, there are a set of fields that are the same, such as those concerning student personal info (email address, phone number, address, etc.). I would like a single script that can do some processing on such fields that are named the same across multiple tables using buttons. In scripting, typically I set the table explicitly via something like let table = base.getTable(“Table Name”); I am wondering if there is any way I can either: Get the table that a button was pressed in or Get the table that a record exists in I know I can make multiple copies of a script and just change the base.getTable() part, but I’d rather keep this as a single script that works on multiple tables. Any suggestions? Thanks!

I am trying creating documents to publish online. I need students to complete fields in the documents. I wan to know if there is a simple way or a tool that can allow me to pull data from any of the following: Google Docs Microsoft Word Google Sheets Also, if you were looking to publish documents online, which is better Google Docs/MS Word. I know MS Word wins hands down for advanced document editing features. But I want to know in relation to online publishing and connecting with other apps and websites. Thank you.

Let’s say I have two fields sitting next to each other in a table. One is called Calculated and one is called Static. The Calculated field is, of course, a formula type field and the Static field is a currency type field. I want to automatically save the result of the Calculated field as a static number in the Static field. For example; if the Calculated field is a formula consisting of =10+5, then I want the static number 15 to appear in the Static field. I don’t want to formula itself in the Static field…just the result (15) of the formula from the Calculated field. Does anyone know how I can accomplish this in Airtable? Much appreciated.

Hi there, I have a “Ref” formula that is pulling the date from another field. Most of the time, when it’s an “AM” time, the date comes through incorrect. I’m guessing it’s perhaps a time zone thing? I say “most” as there are a couple of mornings that ARE correct :woman_shrugging: “Ref” formula = {Name of Worker}&" - "&“Inc:”&DATETIME_FORMAT({Incident Date & Time}, ‘DD-MM-YYYY’) In case it makes a difference, this data is pulling through via Zapier. Any ideas? Thank you in advance, Katie

I’m having trouble prefill-ing a “checkbox” field. I’ve followed the guide on the support forum (I’m not allowed to link it here for some reason) and everything works, except for my checkbox field. I’ve tried “1” “true” “checked” (which is stored in the table/grid view tied to this form). None of these work. What is the proper value to pass in URL parameter to have this field “checked” on load?

Hi all! I’m trying to add the functionality to my airtable wherein a viewer/editor can add a note to an existing entry without having to type over the entry. Ideally, this would function like a digital sticky note, so I can view the comment, but it doesn’t impact the structure of the airtable itself. Does anyone know if that’s possible? Thanks in advance!

I’ve got a single-select field, and I’m trying to change the selection for multiple records simultaneously. I feel like I must be missing something?

I have a database I am creating where users can add entries with the form provided. However, is it possible to have it where a user can also edit the data? Like a wiki page? I found this, which has an edit button. Is this an Airtable feature, or is it exclusive to the miniextensions setup? https://app.miniextensions.com/cards-gallery/w8Gx58SrkZSVX7CzGPcL

I have used sync before to sync two tables, and it is a great feature. What I want to do now, however, is to copy a table from one base to another, including all of the views of that table and all of the lookups and linked (etc) columns that I have painstakingly built. It seems that I can share a view and copy the data over, no problem - a new table is created on the target base with the data. However, it looks like I can only share one view - I don’t see a way to share all the views of a table at once, and if I try to share one view at a time, each share creates a new table instead of adding the view to the previously created one. It also seems that only the data is moved over, but not the customized field type - so if the content in the column is (in the source) drawn from another table (and that table already exists in the target base) it doesn’t matter. The data still comes over as just text. So if I understand this correctly, I will still have to go back and set up every col

Hello everyone, I am new to Airtable and hoping this will be a solution for my business. Before I get into my issue, I’ll explain a little bit about my database. I own a machine shop and am wanting to use Airtable to enter job information and print job travelers to send out to the floor. I am working with 2 databases. The main database being the “Job Tracker” which keeps track of each specific job. The other being my “Client” database. The main purpose of this is to reduce data entry and hold all the contract information for the client. My issue is with Airtable I can easily create a link to the “Client” database. This displays the “Contact Name” which is the primary key. I can click expand and bring up the entire record. Ideally, I want to be able to select the Contact and populate fields in my main “Job Tracker” database with the contact information (phone, e-mail, and company). The reason this is important is I am using a ZAP that automatically populates a form. Since Airta

I have zapier adding records to my Airtable but I have no idea when the record is added. Is there a way to have a date column that automatically adds a date to the record when it’s added?

I’d like to conditionally render an element depending on whether or not comments exist for a record. I’ve tried several methods but the element will not render/disappear unless I reload the app. Here is one example: {record.commentCount > 0 ? <div class="comment-indicator"></div> : ''} This isn’t the case for rendering elements using getCellValueAsString() where I am able to render based on other record attributes. Can anyone help me understand what’s happening here?

Has anyone used Amazon and Web-clipper? I’d like to use web-clipper alongside my asset management table so that on the order completion page of amazon I can clip the items ordered and who they were sent to. That would save me from manually putting in each item. I’m wondering if this is possible before I upgrade my account.

The CSV Import app will merge records from a CSV file with existing matching records and create new records in the target table. As far as I know, it’s not possible to merge/update only without adding new records. Am I missing something? Thanks.

I have a bar chart that uses a date/time value as the x-axis. The column that it is using is configured to display in my local time zone without the time value (see screenshot). However, on the chart, the record appears to be included in the bar for the next day (which would make sense if the chart was showing the dates in GMT). Is there any way to specify to use the local time zone for displaying with the chart? EDIT: We only just started noticing this behavior in the last couple weeks. I’m wondering if there has been a recent change to how charts are displayed?

Hi :slightly_smiling_face: , I have a question regarding connecting record to email thread. What I want to achieve is to know if I received new email from the client. Do you have any ideas on how to achieve this? Thank you. :slightly_smiling_face: