Other Questions

I would like to create a time bound report showing how long each contact resides in a given status? Thanks

Hi all, [Spoiler: I’m not an IT professional and am pretty new to AT, so thank you in advance for bearing with me :slightly_smiling_face: ] I have made a ‘contact’ base to hold client addresses, with the following fields (these need to be split out this way for other operations elsewhere); Address 1 Address 2 Town/City County Postcode Very often, one or two of these are vacant (usually Address 2 and/or County). Postcode might be, too. Ideally I also need to show an address as a single line, with the fields separated by commas. When I use the formula; CONCATENATE({Address Line 1}, ", ", {Address Line 2}, ", ",{Town/ City}, ", ",(County), ", ",(Postcode)) I get commas between the empty fields; Is there a way to skip the empty fields to give the output format; Addr1, City, Postcode, if those are the only fields populated? Thanks for any help in advance :slightly_smiling_face: Mike

Can Airtable be linked with an Access database? I have an Access DBF with multiple tables and relationships and would like to have a mobile device interface. Thanks

My wife has started making masks and I’m looking to make a small form to help her take orders. I think airtable is a wonderful tool and I was looking for an opportunity to test it. I think it would be perfectly suited for that! I have two tables : a first one, with the name of the fabric (primary key) and a photo of the fabric a second one, for order with fields (name, first name, …) and a linked field on the primary key (name of the fabric) I generated the form automatically from the order table. I have the possibility of selecting … the name of the fabric (logical will you say to me, it is the linked field). I would rather that the form proposes on the photo of the fabric (rather than its name)? Would it be possible? Thank you by advance :slightly_smiling_face:

I am trying to find the best way to secure my airtable. I will have a secured membership site. When someone is in the site I would simply want them to click on a button to access the airtable views. Since they already need a UN and PW to get to my membership site I do not want to make them create a new UN and PW to get to my airtable. I also am concerned that someone will give out their airtable UN and PW - giving others unauthorized access to the table. I am hoping that there is someway I can give access to the airtable from my membership site. Can the button (link) from my membership site include an embedded hidden UN and PW? if this was possible then the only way one could get access to the table is if they first entered my membership area. Is this something “scripting” can do? I see there is an option to secure with domain and wondering if that is another possible answer to accomplish the same goal. Any ideas on this would be appreciated.

Hola a todos, Ocupe la automatización de cuando un registro cumple cierta condicion en este caso =Vigente me cree esa fila en otra tabla, me resulta ok, pero el registro original era azul y en la tabla que me lo copia queda en celeste, por lo que no quedan como igual categoría. Me pueden ayudar? Gracias

Hola a todos, Hice una automatizacion: cuando un registro cumple cierta condición esa fila entera se copia en otra tabla. Me da error cuando quiero incluir un registro de tipo attachment, me aparece: Failed to construct the value for “Fields”. Me pueden ayudar? Gracias

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