Skip to main content

Solved

7383 Topics
Pascal_Gallais-
Pascal_Gallais-Inspiring
asked in Automations
Make to export a CSV file

Hello,@ScottWorld, after watching one of your videos, I set up a Make scenario to automate a csv export from an Airtable view:I used the CSV "create csv advanced" module and it works fine.My problem is that all fields in the exported csv are surrounded by double quotes:Do you know how I can remove them?Thank youPascal

3664
SilverTaza
M
Mohsen_khaldounParticipating Frequently
asked in Other Questions
Search in all fields (link to record)

Hi everyone! I would like to know if it possible to search in all fields of a table while looking for a linked record (in another table). I tried to do that but I get result only from the first field

2084
Z
Scott_Hoek
Scott_HoekKnown Participant
asked in Automations
Can readonly (free) accounts run automations?

We have an Airtable business account – it's our slow season so we're trying to save some money so I'm working on changing up our base design to be more forms-based.One thing I'm curious about though – say I make an interface with a button that triggers an automatic, then I have a user with read-only access and an unpaid account.  I assume that they would not be able to push that button to run the automation, is that accurate?

72
ScottWorld
R
RosNew Participant
asked in Automations
Is there a way to create a form to add attachment to an exciting record?

Hello,I am trying to figure out how to create a form to add attachment to an exciting record.I have a form that updates  any field including attachment in exciting record but problem is it doesn't keep attachments that was there prior.My main idea is to share a form with anyone online so that anyone could only upload files to an existing specified record and not be able deleting files that were uploaded by others.  Thank you.

1979
H
A
Addie_DunhamNew Participant
asked in Other Questions
How to restrict email input value to addresses that end in ".edu" ?

We are setting up a form that will be filled out by campus staff at many different colleges/universities, so there is no one @ domain. We want to ensure that no one submits a non-campus email address, however, so we want to make sure that regardless of the rest of the domain, it ends in .edu. Is there a way to do that ? They won't be logging in or anything, I just need the form to reject anything that ends in .com, etc.

333
H
matthew_b
matthew_bKnown Participant
asked in Show and Tell
2-way sync Airtable with Sheets, Notion, Salesforce, HubSpot, Supabase, & more

👋 Hi all - wanted to share something I thought you might enjoy!We just launched Whalesync 1.0 - the easy way to 2-way sync Airtable with your CRM, DB, spreadsheets, and other tools.https://whalesync.com/Hundreds of fast growing companies, like Webflow, Descript, and Clay, use us to bring the power of Airtable to their other apps with true 2-way sync.Popular use casesWhen you can two-way sync Airtable with your other apps, you basically unlock super powers. A few pretty awesome use cases include:Creating programmatic SEO pages in WebflowUpdating leads in HubSpotConnecting project teams in Notion/Google Sheetshttps://www.whalesync.com/connector/airtableTools you can 2-way sync with AirtableWe support >15 connectors you can two-way sync with Airtable includingGoogle SheetsNotionSalesforceHubSpotZoho CRMSupabaseMS DynamicsWebflowTry it outWe have 2-week free on all our plans which you can try out here -> https://app.whalesync.com/If ever have any questions, also fee

402
matthew_b
C
Carrie_MoyParticipating Frequently
asked in Formulas
Seeing URL link used to submit form

Is there a way to see which link was used to create a specific record? We use AirTable forms for surveys and have lots of different survey links. I’m looking for a way to see the specific form link that was used to submit that specific survey. Is this possible with a formula?

422
H
T
taylormunroeParticipating Frequently
asked in Product Operations
Is it possible to verify form information before its added to database?

Hello,I've built my database and it is currently working really well. I am now getting users to help grow the database. However, this information must be verified by me before it is directly updated in the database. Is there a possibility of adding the option of verification? Thanks in advance.

556
H
A
AlliAlosaInspiring
asked in Other Questions
Specifics on Synced Tables and Syncing Intervals

Hi all! So, here’s the use case that spurred some thinking… I have a HUGE, monster of a base that is a bit out of control. It contains many intricate rollups that drive some housekeeping/reporting processes. Now that Airtable Sync is available, I’m working on moving those high-overhead processes out to their own bases in the hopes of speeding up the “master” base. One of those processes is a nightly report. The report is driven off of a view in the master base. I synced this view over to a new base, and set up a duplicate of the report. To test it, I’ve been letting it run the past few nights to compare the new version to the current version… and surprise surprise, they are not the same. Current Report: Runs from source/master base, triggered by a zap that runs on a schedule - every night at 8PM a record is added to a table called [Automation Launcher]. This record triggers a script that aggregates the report data, spits out the HTML which is then picked up and emailed by Zapier. New R

17716
P
Margaret_Picker
Margaret_PickerInspiring
asked in Interface Designer
Usability when linking from many to one record

Usability problem when linking to a record from the from the ‘one’ end of a many to one relationship.We visit homes to help people reduce carbon footprint and save money by taking energy efficiency measures.On every visit we recommend or take one or more actions, each of which has a specific ‘deliverable’  that holds standard values for savings etc.The entity relationship is:Visit to action = 1 to manyDeliverable to action =  many to 1We have many different deliverables, over 200. When adding a new action, which is usually done using a form that is prefilled with the correct Visit, the Deliverable field presents a long list that is in seemingly random order. I cannot find a way to sort or group the selection of links. Interfaces do not seem to help.Can anyone advise?  This must be a common issue . . .

53
Margaret_Picker
mfoxi
mfoxiParticipating Frequently
asked in Base Design
Where does this Name came from?

Hey,Can someone tell me where airtable gets the highlighted names from? I can't find any settings. The table is also named differently.BestMatthias

01
TheTimeSavingCo
J
JKrugNew Participant
asked in Base Design
Convert Single Select to a Table

Hi All!I am trying to change a single select field in my base to a linked field, with all the single select options populated as rows in a new table. I have a long list of single select options that I do not want to have to re-type manually if possible.I could have sworn this was possible in the past with a right-click action, but I can't find it anymore (or I don't remember right).Thanks,Jaco

676
J
S
Sharon_VisserInspiring
asked in Interface Designer
Moving groups in Dashboard interface

I created an interface dashboard with several groups (different charts, different numbers, etc.).  For aesthetic reasons (making the data make more sense to execs), I would like to have 2 groups side by side. For example, I would like to have a YTD group of numbers next to a Month's group of numbers.  The YTD and Monthly data will come from different tables, so they need to be in separate groups.  It seems I can only create a new group below or above another group, but I would like to create a new group next to an existing group.  Is this possible? Thanks in advance!

472
S
J
JoVaNew Participant
asked in Automations
Table Syncing - manual triggers

Hi Airtable community,I am an avid user of Airtable for some time now, and am going deeper into spreading data in different bases (within 1 workspace) and letting these bases interact. I checked some other forum posts and the Airtable notes on how to get tables to sync manually, however am only able to find the below:beyond the manual trigger button, there is no way to directly trigger a sync action between 2 tableswork around is to update a record in a synced table, to trigger Airtable's automated sync actionanother work around, or combined with the above, is to use 3rd party tools eg. Zapier to touch a record and trigger a syncI was hoping for another way to trigger a sync action (API or Airtable functionality) directly eg. by automation, so not by doing the above. But to my understanding this does not (yet) exist. FYI I am on a Team plan. The use case would be to overwrite data for scenario management, meaning different bases represent different scenario's that need updating on

235
J
MathieuM
MathieuMNew Participant
asked in Other Questions
Reporting time on a monthly basis - Workspace & bases structure looking for advices

Hello Airtable Community, I've started building a Project management tool on Airtable for a marketing agency that sells consultants time.The Project management part is quite straightforward even though I believe this might change based on the agency needs and internal processes.However, I am now facing some difficulties to implement the "Time reporting" part to this tool. (bases are connected) :   1 - Project (information regarding customer, start/end dates, tasks, sub tasks, consultants,  #total available hours, #total spent hours #nb of tasks completed ...) This is meant to organize projects, track budget and project progress. Projects, are tracking time on related tasks. 2 - Tasks (information regarding the tasks to perform : start/end dates, sub-tasks, status, priority, consultants, predecessors/sucessors, time for the task, time spent on task ... ) these are the main action to perform within a project. Tasks are tracking the time spent on related subt

193
Mike_AutomaticN
A
amacNew Participant
asked in Automations
Support for adding _single_ actions at the *end* of an Automation Repeating logic block?

Use-case: As an Automation user, I have a use-case where I want to on a weekly scheduled (cron) basis query records that meet the criteria in one table and then create new child records of another table to the parent table and then email a consolidated report that includes the newly created childed records to the relevant recipientsCurrent outcome I can use the `Find` action to query for the specific and relevant records just fine, however, it is my understanding that once I use a `repeater logic` block, I can't "exit" the loop and append an Action outside of the repeater block once that the repeater has finished,Is my understanding about this feature limitation correct? Current work-around: I set up two separate Automations, both triggered by a cron schedule:The first Automation is triggered by its cron schedule, finds a list of records and then in a repeater block iterates thru each record in the list and creates a child record of a differ

94
A
S
SBeauNew Participant
asked in Automations
Need help pulling info from one table to another

Hello! I am currently pulling info from Jira into a table, and then pulling Sprint Start / End dates from Jira into another table. Because Jira doesn't expose that information directly, it is pulled into a GSheet, which I then pull into Airtable.The Sprint Name is pulled from Jira directly into my main table, and there is an exact match for each in the Sprint Info table. I created a Link to Another Record field which sources from the Sprint Info table, and corresponding Start / End date Lookup fields based on that table. I created an Automation that looks for any records in my main table that have a non-empty value and updates the Sprint Info 'Link to' field with the value from the Sprint field (screenshot below).When I generate a preview of the automation results, I can see that the Sprint Info linked field gets a value, but when I go back to my table, nothing is actually being updated. Any idea what I might be doing wrong, or a better way to accomplish this? 

213
TheTimeSavingCo
J
Juan_Gutierrez1Participating Frequently
asked in Other Questions
Report creation and PDF export

Good morning, what alternatives are there to generate reports or export our views to PDF that are available for the free plan (I know that in the payment plan is the export to google docs).Thank you very much for your support

1368
U
O
OskarLNew Participant
asked in Other Questions
PDF export of multiple records

Hello AirTable Community,I am trying to export multiple AirTable records in one PDF. Concrete case is a list of samples that have several values, I want to create a pdf that will be handed to the lab for testing containing a list of multiple selected records in a nice format, not just a CSV. Are there any tools or extension for that? I couldn't find anything so far. If this is not possible in AirTable, does anyone know a work around? For example exporting a view as CSV and then automatically converting the CSV to the PDF format, maybe in Google Workspace? Or through the interface?Thank you very much!

1515
U
P
Paul_ThompsonKnown Participant
asked in Show and Tell
Automation to update a long text field with the value in a computed field.

I need to pull some data from a computed field (actually a filtered lookup field) in Airtable to prefill a form in Jotform. It should be easy as Jotform have introduced the feature (bizarrely under the publish menu) but despite several ways of trying, it will not map to computed fields.My inteded workaround is to map it to a long text field which an automation would update with the value from the lookup field, triggered if the lookup field is not empty. On mapping the fields in the automation, Airtable greys out the lookup field {Instruments} reporting the same issue as occurred whilst trying to mp directly from Jotform, that the field cannot be used because it's computed.I've spent a whole week on this. I've tried converting to text, using a string, an array, and concatenating, but of course, they all need computed fields to hold and reference them.  Anyone know a workaround? Post edit/after thought....Perhaps I can use a script with the same trigger but I'm not really a scr

393
DisraeliGears01
L
LaurenMaineInspiring
asked in Formulas
Combining Dates from Multiple Fields

We're a publishing company and we keep track of content that we publish over the course of the year with these different columns showing publish dates. I'd like to do 2 things:Create 1 column that combines the dates (combining them so that they remain separate would be ideal, but otherwise, it could just be text formatted like this "MM/DD/YYYY, MM/DD/YYYY").Then I'd like to have another column that shows the oldest date and a column that shows the most recent date.Another column that just adds the number of times the content has been published, so counts the number of fields with a date in them.The error you see currently in the far right field had the formula that I tried on my own which was:DATETIME_FORMAT({Publish Date 1}, 'MM/DD/YYYY') & "," & DATETIME_FORMAT({Publish Date 2}, 'MM/DD/YYYY') & "," & DATETIME_FORMAT({Publish Date 3}, 'MM/DD/YYYY') & "," & DATETIME_FORMAT({Publish Date 4}, 'MM/DD/YYYY')A screenshot is attached. Thanks in advance!

135
L
tylermwise
tylermwiseNew Participant
asked in Development & APIs
How to use updateRecordAsync

Hey!I am trying to update a record based on the user's id, currently, I have this code but for some reason it errors saying: TypeError: Invalid arguments passed to table.updateRecordAsync(recordOrRecordId, fields): • recordOrRecordId → recordOrRecordId should be a Record, not a number (5) or recordOrRecordId should be a string, not a number (5)Basically I am trying to update the field URL for the user based off their user id, the text I want in the field URL is from the "strHash" stringlet table = base.getTable("Participant"); let record_id = inputConfig.record_id; await table.updateRecordAsync(record_id, { "URL": strHash })   

743
tylermwise
A
amadeusNew Participant
asked in Development & APIs
Updating the choices from a singleSelect

Hi, I want to update the choices a singleSelect field has without adding a new record.I tried this approach, but that yields the following errorTypeError: Cannot add property 2, object is not extensibleHere is the relevant code (MtypeName gets its value from a singleLineText field)let MtypeName = Mtype.getCellValueAsString("Meeting Type") let Types = MeetingsTable.getField("Meeting Type") Types.options.choices.push({name: MtypeName}) I this possible without residing to API calls?If this is only possible using the Rest API, I suppose I cannot use this without providing the authentication details, right ?

221
TheTimeSavingCo
I
I-RogersNew Participant
asked in Formulas
IF Formulas Help

Hello. I'm trying to create an IF formula that returns some text if the date field is a specific date. Each date would need its own specific text.e.g. If my date field was 05/01/2025, then the IF formula field would return specfic text (e.g Day 1).The bit I'm struggling with is doing this with lots of IF formulas in the same formula field. (I need about 47 different dates each returning their own specific text. Is this the easiest way to do this or am I missing a trick somewhere? Thanks in advance. 

132
I
J
JWalkerParticipating Frequently
asked in Development & APIs
How do I ensure that a form can't be submitted if the end dates is before the start date?

I've been submitting tests for me event form however there is no restriction on being able to put the end date earlier than the start date. Does anyone know how I can remedy this?Thank you.

594
CristianCG

Badge winners

Show all badges
Terms & Conditions