Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,721 Replies
10000 Topics
Y
Yam_RabNew Participant
posted in Other Questions
Saving attachments locally

I installed the AirTable Windows desktop version . Is there a way to store the attachements locally ? My attachemtn database is huge (over 300 GB) .

121
B
F
Fredrick_EsedoKnown Participant
asked in Other Questions
Cannot add image to my helloworld app

I have my logo.jpg image inside frontend folder of my helloworld app. I tried to call the image but nothing is being displayed. import { initializeBlock, useBase, useRecords, } from '@airtable/blocks/ui'; import React, { useState } from 'react'; function HelloWorldBlock() { // YOUR CODE GOES HERE return <div>Hello world 🚀<img src={'./logo.jpg'} /> <img src='./logo.jpg' /></div>; } initializeBlock(() => <HelloWorldBlock />);

60
F
T
Teacher_LinInspiring
asked in Other Questions
Can I recycle my form to use with other grids?

Hi Airtablers, I’m a total newb here and I’m struggling with forms for data input. I have achieved a passable/usable form on one grid which I would like to copy over and reuse with other grids rather than manually go through all the set-up and again. I’m pretty sure that this can be done since no one likes redoing stuff they already done. But, I have not discovered how. I would really appreciate hearing from you if you can tell me how to basically cut and paste a form from one grid to another. Thank you for reading. T

805
T
H
Hamish_AhernNew Participant
asked in Other Questions
Creating a custom incrementing Primary Key without using an autonumber

I have a table called “Settings” and a field called “Next Number” and a field called “Format” Next Number is 101000 Format is ‘TRnnnnnn’ How do I write a script that when I press run, it updates all blank Primary Keys on my view, with the new numbers in sequence, and updates the Next Number setting, ready for the next time I run the auto sequence script. I have tried using a formula, but that doesn’t work because I need to use the next number from the other table, not from the same table. I have tried using a script but I get an error all the time trying to update my barcode primary key, so thats very weird. Type 'string' is not assignable to type '{ text: string; type?: string; }'.(2322) and Can't set cell values: No record with id rec711laJqEuPh65f exists I have looked at all of the script examples. but there are not nearly enough simple examples to do even basic things like updating a simple barcode field. Thanks in advance.

350
H
E
Elizabeth_BarkeNew Participant
posted in Other Questions
Advanced linking

Hi - I need help with advanced linking and maybe formulas or rolls ups? I have 4 tables. Roles Products Content types Services I created a 5th table (Touchpoints). I want to take the names from the 1st column in tables 1-4 and populate the first column in table 5 with them. So that the values in table 5 are linked back to their original tables. However I do not want all the values from tables 1-4 to be used in table 5. And I want to be able to add values in table 5 that are not coming from tables 1-4. Also I would like to add an additional column in table 5 that automatically populates for each record if it is a person, a product, a content type, or a service based on which table (1-4) the record came from.

136
L
F
Fredrick_EsedoKnown Participant
posted in Other Questions
How to show and hide loading image

I need to show and hide a loading image as my records is being fetched from airtable using the documentation code below import { Loader } from "@airtable/blocks/ui"; const loaderExample = <Loader scale={0.3} />; here is my code. can someone help me access.js import {initializeBlock, Loader, useBase, useRecords, table} from '@airtable/blocks/ui'; import React, { Component } from "react"; import {base} from '@airtable/blocks'; function Access (){ const base = useBase(); const tab = base.getTableByNameIfExists('empoyee_table'); const records = useRecords(tab); return ( <ul> <h1>Show Employee Records</h1> <br /> {records.map(record => { return <li key={record.id}>{record.id}</li> })} </ul> ); } initializeBlock(() => <Access />); export default Access;

00
F
L
Lori_Ann_ReinhaNew Participant
posted in Other Questions
Can't upload attachments

All of a sudden, I cannot upload attachments. Help file solutions are not wroking. Suggestions? Thanks

11
Justin_Barrett
S
satya_mahantaParticipating Frequently
posted in Other Questions
How to set table record limit

Is it possible to set record limit in a table…If i created a table that will be contain 10 record max,this size should be fix .Can not create new row…is it possible kindly guide me…share some pic that help me easier

484
ScottWorld
M
Matthew_MaslankNew Participant
posted in Other Questions
Can I turn off highlighting for Lookup field table items?

Hi all, I would like to just have clean text in the PDF. The highlighted lookup fields not only retain their field color but don’t respect default fonts. Thoughts? Thanks, Matthew

22
Justin_Barrett
P
Pjero_KusijanovKnown Participant
asked in Other Questions
Filter where {date) is equal 2 days from today

Hello, can anyone suggest how to create a filter where {date) is equal 2 days from today. The {date} is from Airtable and it is a lookup field. This will send email to client 2 days after the service was provided. Thank you for help

340
Justin_Barrett
E
Eric_van_DalenNew Participant
posted in Other Questions
Invalid Permissions, Refresh Page

Hi, I get an error on my AT - Invalid Permissions, Refresh Page Any idea how to remove it?

21
Justin_Barrett
H
Hal_AtkinsNew Participant
asked in Other Questions
Possible to script a "send this record to Asana"?

Would love to know if it is possible to use the Script Block for something like this - basically, send a record to an Asana Board and create a ticket with certain fields. Is that possible?

320
B
F
Fredrick_EsedoKnown Participant
asked in Other Questions
Navigating from one page to another with airtable reactjs

How to navigate from one page to another with Airtable reactjs I have 2 pages(home.js and access.js) linked to index.js when I run the code via block run. it says Bundle updated but am seeing this error in my airtable Error: Objects are not valid as a React child (found: Error: [object Object]). If you meant to render a collection of children, use an array instead. in Error (created by Context.Consumer) in Route (created by HelloWorldBlock) in Switch (created by HelloWorldBlock) in div (created by HelloWorldBlock) in Router (created by BrowserRouter) in BrowserRouter (created by HelloWorldBlock) in HelloWorldBlock in div (created by BlockWrapper) in Suspense (created by BlockWrapper) in BlockWrapper (created by ForwardRef) in ForwardRef throwOnInvalidObjectType@https://localhost:9000/__runFrame/bundle.js:59956:15 reconcileChildFibers@https://localhost:9000/__runFrame/bundle.js:60856:31 Here is the code index.js import { initializeBlo

120
F
K
Kristin_RoseNew Participant
posted in Other Questions
Linking tables and tallying results

I am getting close to getting this right but need help with one aspect. I have set up two tabs, one tab has responses from my questionnaire and another is going to chart the results. When I have a field that reads a certain word from my response table “ie, red” I want it to tally in my chart tab as 1 response was “red” I have linked the two charts but this isn’t automatically populating, can anyone assist? Thanks!

121
Justin_Barrett
M
Martin_MNew Participant
posted in Other Questions
[BUG] Filter set to "is" acts as if it's set to "contains"

I’m having a lookup table in my view and I like to filter using elements from that table. I create a precise filter using the “is” statement. However, it does not work and other eletents also display – as if I had chosen “contains.” I’m now forced to exclude with an AND statement other elements, thus making my filter bloated. Please see here the screenshot: https://i.imgur.com/QhOjN4I.png

21
Justin_Barrett
C
Celina_RollonKnown Participant
posted in Other Questions
Building Better Graphs

Hey Airtable Fam. I would love to build better graphs. Is the chart block super limited or am I just doing it wrong. Here is a graph of the ages of my database. I can only see the number if I hover over the age block. How can I get it to show the number of entries per age? or if I had them as percentages (I guess by building a formula to show percentage of the age and then making a chart from that) Any help to make my charts better would be massively appricaited. Thank you

93
C
D
Dejean_BrownNew Participant
asked in Other Questions
Looking to automatically split a database

I am looking to automatically categorize information submitted in a form into individual databases based on 1 question in the form. is this possible? I was thinking that maybe all information is submitted to one database and then split into multiple bases automatically based on some sort of linking. Can anyone help?

172
D
D
Darrin_HaweNew Participant
posted in Other Questions
Limiting available choices in a linked field

I’m still plugging along with an Airtable portfolio/project tracker PoC used to support our weekly reporting requirements. I would like to have unique milestones (i.e. different sets of milestones) tied to specific projects. Currently, I have 3 tables with the following (relevant to this discussion) information: [Portfolio] – {Project Name} - Primary field – {Milestones} - linked to [Milestones] table. [Status Report Entries] – {concatenated Project Name + Date/time formula} - Primary field – {Project Name} - Linked to [Portfolio] table – {Status} - Long Text – {Milestone} - Linked to [Milestones] table [Milestones] – {Milestone} - Primary field – {Project Name} - Linked to [Portfolio] table When our managers enter information into the Status Report Entries table, I would like the {Milestone} field to only pull milestones available for a specific project. Ex) [Milestones] has the following sample entries: {Milestone} = Field Work , {Project Name = Proj 1} {Milestone} = Stakeholder App

61
D
E
Ellen_EdgertonNew Participant
posted in Other Questions
Why won't it let me define my rollup field?

I’m trying to do EXACTLY what is shown in this video: Airtable - Support Rollup field overview   A rollup field performs calculations or formulas on specific cells from records that are linked to another field in your table. Sound complicated? It’s not! Watch this video guide and get started... Yet, when I create my new Rollup field, and select the field that links to the other table, it won’t let me do anything more and instead I get a message in the formatting tab that says, “Your field is not fully configured. You need to have a valid field configuration in the formula tab before adding formatting options.” But there is no formula tab visible to fill in. Why is it showing me this message?

381
M
A
Arnaud_WAENDENDParticipating Frequently
asked in Other Questions
Calendar use case : 1 training, with 3 dates and 3 coach : how do you get each coach planning?

Hi everyone ! Here is my issue : I have to manage the planning of different training session. For each session (ie : each entry), I have 3 dates, and each date has a trainer : Training A / Date 1 / Trainer 1 / Date 2 / Trainer 2 / Date 3 / Trainer 3 Training B / Date 1 / Trainer 1 / Date 2 / Trainer 2 / Date 3 / Trainer 3 … Each trainer can be on different session, and different dates. In the end : how can you get a personal planning for each trainer ? :thinking: Since filters apply to the whole entry, I have difficulties to keep only the date related to a specific trainer. I suspect I may have put my hands in the script blocks but if you have a workaround, I’ll take it ! Thanks ! Arnaud

105
ScottWorld
S
Shaun_HughstonParticipating Frequently
posted in Other Questions
New Record In View Multiple Times

I am using the Zapier trigger for ‘New Record In View’ to get records that have a date field that is equal to today’s date. However, as I understand it, that trigger will only work the very first time that record is shown in the view. Each record will show in this view once per year, and I’d like it to trigger each year. Seems like it won’t do that if it only triggers on the first time in that view. Is there a workaround for this?

1013
M
B
BromNew Participant
posted in Other Questions
BUG: Multiple Select Loses Data on Import

A simple export of a table as CSV does NOT come back in tact! I added a period to another text field using Notepad to make the simplest change possible without formatting issues. Then, I imported the same CSV I exported save for the 1 period added within a text string (so it would update the record). The multiple select column kept only ONE selection for the updated row… I need to be able to import updated content reliably. This is not proving to be the case.

71
M
A
AM858Participating Frequently
posted in Other Questions
I need to import property data with a one to many relationship

Hi all - I have some real estate data I want to import which is a list of property information and contact information associated with that contact. So one owner, who was a unique mailing address may have a relationship to one property or to many other properties. Is there a way I can import the data in the link below into a “Properties” Table and a “Contact” table? When i’ve done this in the past, it has imported without connecting the relationships together. docs.google.com Sawtelle_OoC_<10U_1-17' Sale Sheet1 Owner,Primary First,Primary Last,Secondary First,Owner 2,LLC Owner Name,Possible Relative Name ,Deceased Relative Name ,Wireless 1,Wireless 2,Wireless 3,Wireless 4,Wireless 5,Wireless 6,Wireless 7,Landline 1,Landline 2,Landline 3,Landline...

31
M
X
XingKnown Participant
posted in Other Questions
Random 4 digits numeric from Formatter by Zapier

I recently got a response from the Airtable team that we may get back the random number from Formatter by Zapier. Here is the idea Airtable-Formatter-Airtable I want to have a random unique combination of four digits, the “0” ( or “00”, “000”) can not be in the beginning, I need some excellent folks to help, because now seems really possible that I’ve been trying to understand this Formatter to convert data into a different format. Let’s try to make this happen.

21
G
M
Matteo_PotaNew Participant
posted in Other Questions
Exporting view to csv download - phone numbers incomplete-field is phone field

when I download a view the telephone field (column) is incomplete - only (845) is downloaded and not the whole telephone number. field is defined as Phone. Thank you for your help!

61
ScottWorld

Badge winners

  • Welcome
    jt_hkhas earned the badge Welcome
  • First Solution
    AviChas earned the badge First Solution
  • First Solution
    mirbrookhas earned the badge First Solution
  • 25 Replies
    Rodney_Beadonhas earned the badge 25 Replies
  • First Reply
    PA at bphas earned the badge First Reply
Show all badges
Terms & Conditions