Other Questions

Is there a way to make a URL for a field or a record such that I could include it in an email and someone with access to the table could go directly to the field/record I am talking about?

So far I’ve had no trouble entering text and currency into Airtable bases, but I’d like to calculate simple percentages from my numbers. I’ve looked everywhere and can’t figure out how to do it in Airtable. I know how to do it in Excel and Apple Numbers. But among all the templates, I haven’t seen any with percentages. I’m starting to think that it’s not possible to calculate simple percentages in Airtable. Or am I missing something? Thanks very much in advance for any help with this.

Do you have any idea why I failed to send this? I just set this up and I’ve used it only to send two emails, so I don’t think it’s spam-related.

My iPhone 6s makes no sound alert when I am @mentioned. I have already tryed everything. Just factory reseted it but it keep on not making any sound. Can not stand looking the hole day to my phone waiting for messages anymore! Can anybody help me??

I have two tables: Contacts and Companies Multiple Contacts can be linked to Company record. Both share the same “Application ID” Field. For some reason when I run the script only handful of records are linked. The linked field is the “Company” field in the “Contacts” table. //Define the company table and query let cmpTbl = base.getTable("Contacts"); let cmpQuery = await cmpTbl.selectRecordsAsync(); //Define contact table and query let cntTbl = base.getTable("Companies"); let cntQuery = await cntTbl.selectRecordsAsync(); //Loop through the records and find the Contact ID for (let record of cmpQuery.records) { let cmpid = record.getCellValue("Application ID"); //Loop through linked table and match ID values for (let cntRecord of cntQuery.records) { if (cntRecord.getCellValue("Application ID") === cmpid) { //Update field cmpTbl.updateRecordAsync(record, { 'Company': [{id: cntRecord.id}] }); } } }

Hey all. I did some searching through the forum and support but don’t see this scenario. I’d like to use a Button Field to decrement (remove) one unit another cell (Quantity on Hand). The process would be to scan QR on a label made by page designer. On mobile you’d tap the button, REMOVE 1 Button action subtracts one from the QOH cell of that record.

I have multiple needs for a foreach function that would execute on each element of an array. (Side note, there’s nothing that seems to properly count the number of elements in the array.) The main example is a Date Field on one table being rolled up into a list of dates on another table. All formatting is removed. The only options in the rollup are array functions after the dates are already joined into the “values” variable in the field. Then the result is not a date and cannot be formatted. If we could do a foreach, there would be a tremendous amount of power available and I could address this situation easily by saying “Do X on each element of the rollup values, then join them together in this format.”

I am new to Airtable so please be patient. I have my contacts for clients loaded into my Airtable. I want to send them all a survey. These are clients I work with regularly so this is not considered spam. Their responses will dictate how we will conduct business going forward. If I send a survey through Airtable, it keeps ending up in spam. I tried using a google form but, it limits me to sending out 100 emails at a time. I have thousands of clients that will receive the survey. Is there a way to send the survey through Airtable and have it go to their in box?

I am aware that when I share a grid view, the person whom I share it with can only view and cannot edit it. Is there a way to enable the person to edit the shared grid view?

I was collaborating on a table with another free user…and it is quite a complicated table, but was created by my collaborator. I upgraded my account to the paid premium account, and I can apply the premium features to the tables that I created myself but not the one shared with me by the creator that I collaborate with. Even when he added me as a “creator” designation, it still shows that I have some tables in a free account. How would I resolve this?

I want to display the map, but allow filters to be put on it. e.g. business type, or days open (which are fields in my database how can I do this? Thanks.

I want to display this view only externally to allow others to search my database. How can I do this? I don’t want them to see all the underlying data

Hi, I’m trying to write a custom app that will visualize data held in linked records in my base. The base captures interactions between systems and I want to show this as a UML Sequence diagram. I wrote a script app that generates all the UML diagram script but I want to be able to display the diagram itself when a user clicks on an interaction record. I’ve taken the URL preview custom app as a base as I’m basically rendering in an iFrame the visualization using various javascript/css libraries. But I can’t traverse the base to access linked records without either: a) getting a meta-data not loaded error if I use queryResult.getRecordById(…) b) Rendered more/fewer hooks error if useRecords(queryTable) and find my record in this result. The code for approach (a) is using an interaction record var activityLinks = interaction.getCellValue('Activities'); var activities = activityLinks.map( actLink => activityQueryResult.getRecordByIdIfExists(actLink.id) ); This is one of th

We use linked records to create sub-tasks (the tasks are in one table, sub-tasks are in another table where the entries link to a task) However, when you look at all the subtasks for a given task, you cannot filter out “completed” subtasks. As a result, it crowds the view. One solution is to unlink the subtask once it’s completed, but then you can never go back and figure out what task that subtask belonged to Is there any field we can create in the Subtask table that will capture the Task it is linked to, and then preserve that information even when it’s unlinked? Thank you!

Hi there I have just come across the airtable search app. The background to my question is that I run my own (very small) recruitment/staffing agency and I have 1000’s of CV/Resume documents. Whenever a client gives me a new vacancy I will run a boolean search within my existing Recruitment CRM/ATS product and it will search through the CONTENT of each pdf/word document and show me matching candidates e.g. I might type… (Java OR c++) AND (developer OR programmer OR “software engineer” AND (bank* OR “hedge fund”) …and it would search within my 10’000+ pdf/word documents and present me with the documents that fit the criteria. Does anybody know if the airtable search app can search within an attachment in a table or can it only search the text within each block/table? Many thanks and warmest regards Tom

I am trying to compare a value from one table against that value in a separate table to see if that value is on the one table. I did find code to get this to work and it seemed as though it was working, however I am finding that there are matching values in both tables that are not showing. It looks like the code is refusing to look at or compare values beyond the first 60. Any help is greatly appreciated.

Best I can come up with would be to have one column that is creation date a second column this is editable date a third column which will display the second column if it exists, and the first column otherwise Unfortunately, this would mean that the place I edit the date would be different than the place I view the date

I have a table of conversation summaries. Each summary recrod has a single select Category column and various columns of Interest. I would like to print a report by category, such that each Category name is printed once and there would be a sequence of records, each with it’s important fields. I am using page designer at the moment, and it almost works. Here are two pages from the reports Category I can live with the category name being repeated for each record. What I can’t live with is each record taking an entire page when most records are only a few lines long. Any way I get it to put as many records as will fit onto each page?

Hello all. First post to the community so fingers crossed! I’m trying to use a system of nested tags within Airtable. I would like to use a simple Child - Parent table to represent multiple layers of relationships (which works great with the Org Chart block by the way). For example, first table like this: CHILD / PARENT UK / Europe London / UK Westminster / London Downing Street / Westminster etc. I then might have a diary table where I list places I’ve visited. For example: DATE / LOCATION 10th May / Downing Street etc. I’d then like to be able to filter by when I’ve been in Europe. Clearly Downing Street should count, as you can see from the Parent/Child table. I’ve been trying various lookups / rollups etc. to figure this out and can’t manage it. Any tips much appreciated! Thank you.

Is anyone else having an issue ordering their workspaces? Every time I move a workspace, it falls back into its original position or a different workspace is moved. The goal is to move my workspaces into alphabetical order, but they keep randomly shuffling when I try to reorder them.

The person whose name our Airtable account was under left the company and never made anyone else the new owner. Is there a form or documents we can send in to transfer the account to a new owner?

I’ve got right now 10’ mins of delay un my automations triggered by a view, any one with this issue??

I have a calendar view in my AirTable base. The calendar shows activity based on a date. Currently it shows individual records that have activity on that date, but I would like to show a grouping per date instead of individual records: Example: October 13th Calls Made: 102 Texts Sent: 133 Emails Sent: 78

Hi everyone!, I’m getting stucked in this problem and I hope you all can help me with some guidance. In my company, I’m in charge of controlling the number of tasks the employees can do in a month. In order to organize this, we use a webapp that schedules the tasks. The problem is, I have to check manually person by person to see if the exceed the maximum number of tasks. Is there an integration, a source of coding or anything that can import this info from the webapp to airtable? (This is the critical step in my opinion) Thanks for any help that anyone can make :grinning_face_with_smiling_eyes: