Other Questions

Is there a way to fix scatter plot axis ranges to a specific value rather than having them automatically adjust to the input data?

Not sure if this was asked. But using record listing interface for table A with a related table B. When you click, you end up at the backend of Table B and not another interface. How can you set this up?

Hello, i have an airtable table where i have addresses, i am looking to get coodinates (lat-long) from them, after doing many researches i found some paid airatble extensions but also a platform called positionstack that offer a free plan to achieves geocoding. They have an api to do it remotely. seems that it need to call it from airtable but i don not have any idea how to do it, here is an example for google sheet : https://api.positionstack.com/v1/forward?access_key=YOUR-API-KEY&query=+++sheet_name!C2:C11+++ Any idea how to do this on airtable ? here the api doc page : API Documentation - positionstack

Is there any option to directly fetch the collaborator name whoever is entering the record? I am using a shared base. If the above thing is possible, is it also possible using forms? Thank you in advance.

Hello all, I hoped to close a project that I worked on for a few weeks today just to realize that synched tables do not behave as I expected. Using synched tables, records get a new Record ID in the destination. My workflow works a lot based on (pre-filled) forms. Now how can I pre-fill a form with a record from a synched table? Cheers Christoph

Hey, I was lost with pagination issue with QlikSense REST Connector but found a solution, here it goes: Pagination Type: Next token 'Next token' parameter name: offset 'Next token' path: root/offset :smirk: Luigi problems qlik airtable error 422 pagination offset token solution HOPE ‘IT’ REACHES YOU WELL :stuck_out_tongue:

Hi. I’m creating some new documents in the Page Designer block. Some fields that I’m referencing from my base do not always have data in them. Airtable is putting “lorum ipsum” placeholder text when the field is empty. Is there a way to turn this off so that it’s just blank? I created similar documents before and I don’t recall having this issue. Is the placeholder text a new “feature”? Thanks! ~ Geoffrey

Is there a way to embed a youtube video in a grid view card so the video is playable inside the card?

Hi, I am facing the same issue. I want to record time and send a notification to Discord whenever someone fills a form, but it shows in seconds only. How do I show it in HH:MM. It records in seconds as of now Could anyone please guide me.

I’m trying to find a way to send a copy of a form submitted by our Account Executives by using something else besides automations. I have only 2 slots left of the 25 limit and would rather not use them for something as simple as this.

I have a restaurant tracker that enables me, my wife and my 2 boys to each give it a rating using 1-5 stars. Is there any way to have a field that averages these stars?

I’m trying to create a script in Airtable linked to a button. The process is as follows: Button within Airtable pressed If the checkbox field ‘switch’ is false, then turn it to true Wait for 2 seconds, reset the field to false This is the script I’ve written using the setTimeout() function: let table = base.getTable("EXM"); //The name of the table you're in here let record = await input.recordAsync('Pick a record', table); if (record) { if (record.getCellValue("switch")===false) { table.updateRecordAsync(record, {'switch': true}); output.text('checkbox ticked'); } const myTimeout = setTimeout(timeDelay, 2000); function timeDelay() table.updateRecordAsync(record, {'switch': false}); output.text('2 second interval'); } When I write the code I get an error that says “cannot find name setTimeout”. As a solution, it suggests “add missing function declaration ‘setTimeout’” How do I declare this function so it can function with my code?

I’m having trouble with something that seems very simple. I’d like where it says “0.9 available” for it to show that time formatted as “h:mm”, as it does in the “Time Available” field next to it. Here the formula for the Name field: Essentially I think I need to convert seconds to hours, minutes and seconds within a formula, but I can’t find a way to do it and feel I’m probably just missing something simple. Thanks so much.

Hi! I am trying to add internal links on my blog that I am managing via Airtable used as a backend CRM. I fetch the blog posts via Airtable API but Airtable always prefixes “http” on internal links, so “/about” becomes http:///about. It’s really puzzling that this is not natively supported and there’s no workaround it seems like such a common use case! I’ve also tried a normal Markdown syntax but, as the docs say, hyperlinks Markdown is not supported in Rich Text Fields (??!!!). Does anyone have any workarounds?

Hello, I was wondering if anyone has ever made a bundles. I want to take about 10 different Items with 10 of each and have it still subtract out of my inventory. I would like to have it work as following: if we use 15 of the bundles it would subtract out 15 X10 of each. This is for Simulation training so we have 6 different Cohorts that will be using the same bundles. What I have will work I just have to enter every Item for each time I use it. Hopefully one of you can help? Thanks

Hi Community, please could you advise me how to filter view by latest date dynamically? I would love to use in filters something like: max(last modified date () ) Thank you, Standa

Hi, I’m using Airtable as my agency CRM. Before Airtable I was using Hubspot. A feature that Hubspot has and that we loved was the information when the client seen our quote. We could know at which time and which day the client opened the quote. Can I make this with Airtable ? Thanks in advance,

I currently have two date fields, start and end. How do I create a relationship between two rows, e.g. Have the start date of Task B be days before Task A end date?

Hi folks, My apologies if this has already been explained. I couldn’t find a way to add an input to a field. I would like to enter any decimal value on the interface and then go through the calculation process. Thank you :slightly_smiling_face:

I manually entered numbers in a Single Line field, then I changed the field type to Number, and the last two digits of the numbers changed before my eyes for no apparent reason. The change is in the last two digits (14 changed to 20, and 05 changed to 00). Note that I didn’t make a typo - I watched the digits change when I changed the field type to number. I tried making a new number field and copy pasted the values in there, but the same thing happened there. I tried the same with a formula field with the same results. It’s not a rounding error - the number field format is set to integer, and so is the formula field. The screenshot SHOULD show the same number in every field - the “Group ID” field has the correct number. Is there a ghost in the machine?

Hi, I could use some advice on the following use case. One base, four tables: Products Orders Order Line Items Out of Stock Products Orders are linked to its Order Line Items, and each Order Line Item record is linked to 1 Product record from the Products table. Additional lookup data of the Product record is gathered in both the Orders and the Order Line Items table. Now here is the main issue: Product records are automatically (via scripting) moved to the Out of Stock Products table once they hit a quantity of 0 (and let’s assume we manually adjust the quantity of these product records). Once a product record is moved though, the link between the Product record and Order Line Item record is removed, causing all the additional lookup and summed up data of my final Order data to be flawed. Somehow, I need to retain that product data in the order. I’m looking for any type of suggestion to deal with this use case to retain the product data in the orders. Could be going anywhere – from

Is it possible to retrieve the possible options within a column’s “Single Select”? Without having a record for each option listed? I have one column with 5 possibilities (right now), and want to retrieve those possible values so I can dynamically build a select box on the front end of my application. I want to be able to change those options in Airtable (add or remove) without having to touch my application. The select box will allow me to create a new record in the table with only the values I’ll allow the table to accept. I’m using only jQuery to interface with the Airtable API, and have been doing well with it (I know it’s not the most secure but it works!)

Hello and thank you for taking the time to help me out! I have two event tables. One for private events and one for community events. Both of these Tables have a Calendar view. I would love to combine these two Calenders into one so that the team can keep track of everything and ensure no overlap. Does anyone know a good and simple way to do this? Cheers! Chris

Hey all, I have a digital display where I’ve embedded a shared grid view. I would like to scale up / zoom in on the embedded view to increase reability. The simple CSS solutions I’ve tried haven’t panned out. Does anyone have a recommendation or proven method for scaling up an embedded view? Thanks, Ray

Hi all, trying to build a table for instrument rentals at my workspace. I posted about this elsewhere thinking my answer lied with automations and formulas but maybe calendar view is my answer? We basically rent instruments to students like a library would a book. I want students to be able to submit a form requesting an instrument, they select a request date and I have a formula that calculates the due date as 14 days past that. I would like instruments to be marked unavailable when requested, this needs to function in relation to the current date (ie, instrument requested for Sept 15-29, today is the 20th, so it should show unavailable) as well as to a future date (don’t want students to double book an instrument say, for October 15th). Would calendar interact with a form in such way and allow me to do such a thing?