Other Questions

Hello, I am trying to create a prefilled form that automatically populates the current renewal date for a piece of software. I am running into an issue where the date that shows up in the form is exactly one day behind from what it should be and I can’t figure out why. As you can see in the above screenshots, the link generates with the date “2023-01-14” but shows up in the form as 2023-01-13. Any clues as to why this is occurring will be much appreciated! Thanks Doug

hello, i have table 1 with invoice nr, product, quantity i want to copy selected records to another table using automations i find the record, that meats the criteria (invoice nr) and want to “copy” those to another table so i make triger, find records (found 4) and now i want to copy those to the table 2 i try to use “create record” (in table 2), but i get 1 row with multiple products - i want to get 1row with 1 product from what i find - please can anybody tell me how to, or what am i doing wrong ?

Hello, Airtable community. I would like to know how I can automatically add the records in Table A to a single record in Table B. I already connected the tables and what I want is that every time a new record is added in Table A, the records are automatically added to the connected field in Table B. I tried Automations, but I couldn’t figure out the process. I appreciate any guidance in advance.

How to remove the calendar-view’s button tooltip?

Is there a way to Filter records within the Grid view based on a search within the table itself? In the same way that ‘Find Mode’ allows this in FileMaker with Command-F. Thank you!

I am trying to create a table that can represent an arbitrary depth hierarchy of objects, with a field that in each entry that rolls up corresponding values from its children. Here is a simplified version of what I want: Each entry has a “type” field that is a selection of “leaf” or “parent”, a numeric “enteredSize” field (used only for leaf nodes), a “children” field with links to other entries, a rollupSize field that is the sum of the size fields of the linked children, and a “size” field. I want the size to be a formula: IF(type=leaf, enteredSize, rollupSize). This is disallowed because of a circular reference. I understand that I could create a circular reference with this, but my data is a strictly a tree. Is there any way to support this? Basically, I want to check circularity between records, not between fields.

Hi, Is there any formula that can be used to find the best matching block from the table? please help! for example, I have an input that’s collective of words as a product name: YELLOW PRETTY WOMEN’S BAG in a meanwhile, my inventory data would have: PRETTY MEN’S SHIRT YELLO WORLD PRETTY MEN’S HAIR RED SALSA PRETTY WOMEN’S BAG …etc and output to be : RED SALSA PRETTY WOMEN’S BAG. because it has the largest number of words matching. *input string isn’t always 4 words combined. PRETTY MEN’S SHIRT (1word match) YELLO WORLD PRETTY MEN’S HAIR (2words match) RED SALSA PRETTY WOMEN’S BAG (3words match) Hope my explanation was good enough to understand. Thank you in advanced.

I need to open a record in a miniExtensions form prefilling values from Airtable fields - including a multi-select field. I’ve used an extension to build a formula. The resulting URL works fine with an Airtable form, which populates all fields, including the multi select. The miniExtension form won’t prefil the multi-select field using the same formula. I can see the cause. The Airtable formula retrieves an array of values for the mini select field. However, it inserts a space after each comma. Can anyone suggest how to adjust the formula to take out the spaces? “Story form” & “prefill_Idea%20Status=” & ENCODE_URL_COMPONENT({Idea Status} & “”) & “&” & “prefill_Story%20title=” & ENCODE_URL_COMPONENT({Story title} & “”) & “&” & “prefill_Magazine%20section=” & ENCODE_URL_COMPONENT({Magazine section} & “”) & “&” & “prefill_Audiences2=” & ENCODE_URL_COMPONENT({Audiences2} & “”) & “&” & “prefill_Magazine%

Hello again, cannot move over this problem :frowning: the situation: Airtable compare - Airtable Explore the "compare" base on Airtable. invoice comes, somebody writes to temp invoice 1 row = 1 product, can be many from 1 invoice then smbdy fills same way the temp shipping note somebody scans EANs (this info is not in this example table) in warehouse when the goods come = we know what product and what qty is in reality what i want from airtable: compare all items on same shipping note (in temporary) with the coresponding invoice, with the reality we know the invoice nr and the shipping note that means nr of products and qty in this step then i wish to compare prices from invoice with the one in product if there is any problem give me info where it is so i can resolve it. seems to be easy, but its not for me (at least this time) - can use automations, make new colums…(i am owner of the db). Thanks for answer or kick in right way :

Hello I wonder if you can help I am using a react.js form to collect customer data and would like to connect this information to Airetable. this is what I have so far: file 1 - data file import { useState } from “react”; import axios from “axios”; export default function useData() { const [data, setData] = useState(null); const getData = async () => { return axios.get(“/”).then((res) => { console.log(“res.data.records:”, res.data.records); setData(res.data.records); }); }; return { getData, data, }; } file 2 index.js import React from ‘react’; import ReactDOM from ‘react-dom/client’; import ‘./index.css’; import App from ‘./App’; import axios from “axios”; const BASE_ID = ‘xxx’; const API_KEY = ‘xxx’ axios.defaults.baseURL = https://api.airtable.com/v0/${BASE_ID}/Contact__form/; axios.defaults.headers.post[‘Content-Type’] = ‘application/json’; axios.defaults.headers[‘Authorization’] = Bearer ${API_KEY}; const root = ReactDOM.createRoot(document.getElementById(‘root’)); root.re

Hello, I have one table with my clients informations, and another that my team must upload the situation of their meeting with thes clients ( each week they create a new card with informations). I want to know if there is a way to meassure the difference in days that a card is created for the same customer.

Hello- Looking for a formula to where if I have multiple fields with single select options to act as an IF statement that overrides the last stage that is selected: So when any of these are selected based on the rules set in the formula, only that stage will show regardless if project status is approved for graphic design and the formula displays DESIGN STAGE, once Graphic Design Status is not blank, it will show the status for that stage - make sense? IF({PROJECT STATUS}=BLANK(),‘’, IF({PROJECT STATUS} = ‘APPROVED FOR GRAPHIC DESIGN’,‘DESIGN STAGE’, IF({GRAPHIC DESIGN STATUS}=BLANK(),‘’, IF({GRAPHIC DESIGN STATUS} = ‘READY FOR REVIEW’,‘DESIGN STAGE’, IF({GRAPHIC DESIGN STATUS} = ‘REQUIRTES REVISION’,‘DESIGN STAGE’, IF({GRAPHIC DESIGN STATUS} = ‘ON HOLD’,‘DESIGN STAGE’, IF({GRAPHIC DESIGN STATUS} = ‘APPROVED FOR SUBMITTAL’,‘SUBMITTAL STAGE’, IF({SUBMITTAL STATUS}=BLANK(),‘’, IF({SUBMITTAL STATUS} = ‘IN SUBMITTAL’,‘SUBMITTAL STAGE’, IF({SUBMITTAL STATUS} = ‘READY FOR REVIEW’,‘SUBMITTAL

It would be great if we could ‘bookmark’ certain base ‘views’ on our dashboard for quick access

Hi there, I’m new to the Airtable. I’m wondering if it’s possible to store JSON data in a cell ? For example, if I have a User table, and inside this User table, I want to store an array of objects for every user about the videos the user has watched. Is it possible ? :thinking: :thinking: e.g. Can I store the data ( similar to the code below) in a cell ? { data:[ {videoId: 1, videoTitle:"some thing", videoDescription:"some text"}, {videoId: 2, videoTitle:"some title", videoDescription:"some text"}, {videoId: 3, videoTitle:"some other title", videoDescription:"some text"}, {videoId: 4, videoTitle:"fourth title", videoDescription:"some text"} ] } What’s the easiest way to create this relationship ? Do I have to create another Video table? :thinking: Any suggestions ? THANK YOU !! Scenario: e.g. User Amy watched video#1, video#2, video#3, and video#5 e.g. User Bob watched video#1, video#4, video#5 ( I have a total of 100 videos )

To simplify the description… I have 1 table that has a field of a Linked record. I need a dead simple way for my teammates to know to Create a New Record. Idea: Create a button with a good label, that opens the new blank record in that Linked Record field. I haven’t found in any examples a way to open a blank/new record on a different table, that is linked to the record where you initiate the process. Please help. Thanks in advance. Dave

Hi- We’re trying to get Airtable to sort a list of records by the most recent linked record. Basically, we want Airtable to ‘understand’ dates in a linked record. Here’s the basic flow: One table we have is the ‘Sponsor’ (advertiser) who has purchased a ‘Sponsorship’ (advertisement) The ‘Sponsor’ is linked to every individual ‘Sponsorship’ that it has bought Each individual Sponsorship is its own record, with a Date field as the primary field in the linked Table What we want is for Airtable to know what date a Sponsor’s most recent Sponsorship ran (or, what is the latest date of a Sponsorship linked to a particular Sponsor) With this, we’d be able to allow our users to sort by Sponsors who’ve run an ad recently (say, in the last 30 days) The problem is that even though each Sponsor has all its Sponsorships linked to it, I don’t see any way to get Airtable to use the linked Sponsorship records to sort Sponsors. We’ve tried a Lookup field of the date of the Sponsorship, but Airtable tr

Hi Airtable Community, With sample scripts that I found here, I was able to create a script to duplicate a record, and I’ve set up the script to run on a button. [So, thank you for all those how-to scripting posts!!] However, I was hoping to be able to limit access to the button, so that only the right people could click and run the script. But, on the button field the option to set “Edit field permissions” is grayed out. I know I can hide the button from certain views, but my users do know how to copy a locked view and hide/show whatever fields they want in their personal or collaborative view. Is there another way to prohibit who can click a button, since field-level permissions are not an option? Thanks for any help provided.

Me again, still working on same database as Going mad trying to avoid duplicates with ARRAYUNIQUE. I’m trying to create a field that shows a date-ordered list of unique dates on which the items on the table are listed in a linked table. The rollup (or a lookup) works fine, and ARRAYUNIQUE() is doing its thing, however the result is a slightly strange, non-sequential order which I think might be related to the creation time of each record. Has anyone got any bright ideas of a workaround that might let me sort this into a sensible order?

Hello community, I’m using Zapier to send data from other apps to Airtable The zap starts with a CRM called Streak, it includes a variable “company helper” with value “Diamir” The Airtable action is writing “company helper” into the “company” field: The data in is correctly shown “Diamir”. But the data out becomes “recPLcGiYMFsYsWPT” Which equals FIT and not Diamir Can someone help illuminate me as to what may cause the difference between in and output? Thanks!

For example you send a form to a client, they complete, save and send the form back with only half the information. They are then able to revisit that same form link at a later stage and see the fields that they can then complete at that later point in time? Thanks Brian

Hi could I get some help. I’m going nowhere with IFs and the Date/Time functions. How do I get make this work to print a result if the DateCreated is 30+ days older than TODAY() Driving me mad thanks

I’m trying to bulk upload records from an excel file. the columns match. but whenever i finalize the upload, airtable creates my new records AND it also creates a boatload of blank records. this is particularly irritating because i am doing an initial upload of many records into a table that has automations that create records in a different table whenever records are created in the current table. so now i have to delete the blank records from the one table, and go delete the blank records from the other table too. is there a way to set limits on what airtable imports from excel? i assumed it would stop importing when there wasn’t data in the cells. but this is not the case.

I apologize if I missed this out there, but I tried searching for a similar answer but couldn’t find one that matched exactly or I could learn enough from. Unfortunately my knowledge of script language is borderline zero. High-level explanation: I have a multi-stage project process that I am starting to build in Airtable that I am curious if am automation is possible, where a button can automatically create tasks from templates as you work through a project. Details: Currently my process has 2 main components, the Submission/Review process and the Launch process, with a task table for each process linked respectively. The tables are laid out like this: Submission/Review Captures new requests from a form and has data fields for review steps Fields related to this automation: Vendor; single line text (primary field) Stage; single choice Assigned to; collaborator Stage tasks created; multi-select with same options as Stage Submission/Review Tasks Houses the standard tasks for each

If I am over my extensions limit, do I need to delete them from my dashboard, or can I simply disable them? I have some that I use very infrequently, but I’d like to keep them around if possible, enable them when I need them, and then disable again.

I seem to have access to a new feature that let’s me build a filter based on an exact linked record object. But the way I get access to it seems to be a bug. If I try to build a filter by chosing a linked record field, I only have the options of [‘contains’, ‘does not contain’, ‘is empty’, ‘is not empty’]. However if I start my filter on a different field type, such as a formula or text field, I can chose the filter option ‘is’. Once I have selected ‘is’, if I then change my filtered field back to a linked record, I have a new option to filter my linked records with ‘is exactly’, and I am presented with a standard lookup list to choose from. Unless I have missed something, this is a huge new feature that I can put to good use. I have added some screenshots, let me know if others have the same thing.