Other Questions

Hello, I’m trying to figure out how a Form view can be pre-populated with information from a record in the grid view - if possible I’d like this information to pre-populate in the description for the form item. The goal is that Form 1 will allow users to submit information that populates a grid view. Then, Form 2 would have some information from the grid view filled-in once that record matches a certain criteria. Sorry if this has been answered and I missed it, or if this doesn’t make sense :grinning_face_with_sweat:

We recently switched from using spreadsheets to Airtable to track advertising sales, and I am quickly learning how Airtable does not have some of the basic abilities of a spreadsheet. In our old spreadsheet way of doing things, we were easily able to total up advertising sales in a field and compare it to an entry containing the budget goal for advertising sales. I cannot figure out how to do that in airtable. The attached image shows what I am trying to accomplish. I have been able to create a summary field in our table that ads up the total sales, but I cannot figure out how to create the budget line and % of budget reached line / formulas. Any help is appreciated!

Hi, im using Airtable to calculate invoice dated from when a client signs up depending on payment method and type. I have a start date, and i have a last invoice date and next invoice date. And im using a formula now to calculate next invoice date based on last invoice date. But if the last invoice date is empty i get an error. What i want to happen is that if there is no last invoice date, it should instead be start date. Here is my current working formula: DATETIME_FORMAT(DATEADD({Last Invoice Date},IF({Payment Method}="Quarter",90,IF({Payment Method}="Partner",360,30)),'day'),'YYYY-MM-DD') And as i said, if {Last Invoice Date} is empty i get an #error. My manual solution now is to just enter the start date manually in the last invoice field. What i want to do is to base the first invoice date on the start date, if the last invoice field is empty. and i tried this. IF ({Last Invoice Date} = BLANK( (DATETIME_FORMAT (DATEADD ({Start},30) ),'day' ),'Y

Hello all! Wondering if there is a way to export selected records to a Google Doc/Word Doc and not all records in a database? I know Page Designer can do this but I would like all of the selected records to be on one document and not broken up.

Hey everyone, I’m trying to use my base to lookup all the field variations for a given primary field input. Basically, I’m compiling a list of games (Title) with different software that add 3D audio (Spatializer) and I’m looking for the most intuitive way for anyone to find the link for the respective Guide by just typing the Title. The closest 2 methods I found are: Duplicating the primary field (Title) so I can change the type to single select. This way, I can set up a form where I can start typing and have it auto-fill with Title options. Then I added the fields I want shown as conditionals and simulated it returning Gears of War record values. Obviously this is just a proof of concept and won’t work with a form since I want people to fetch records, not submit one. Search app. It allows searching by Title and displaying some of the info I want shown, but also stuff I don’t want shown. I also want the Guide link to be clickable instead of having to expand the record. I know

Hello. I have a table where I have created a linked field to establish a new table. When I look at that new table, I notice some fields that are actually duplicates (e.g. the value of a field has a typo.) When I correct that typo, it seems like that record should go away and instead be incorporated into another record. But this doesn’t seem to happen. Here are the specifics. My original table has a field called “Type of Case”. I set up that field to be a linked field and to then create a new table based on it. So the new table called Type of Case has all if the cases (many:1 relationship to Case Name, meaning that an individual case can have multiple types). So, in the new table called Type of Case I see a few duplicates because of typos or inconsistent naming. For example, one type is “Personal Liability” and the other is “personal liability”. When I correct the lower case version to “Personal Liability”, I expect the other one to disappear altogether, meaning that it seems like it sh

Hello AT noob here, so apologies if this is very basic. We’ve set up a simple base that books staff against sites and dates. I want to make sure that we don’t accidentally double book a staff member on two sites on the same day. I have a field that logs each date a staff member is booked to work - I’ve tried to use deduce to identify any instances where are staff member has two identical dates booked, but I have so far not managed to make it work. is this the right way to go about it or is there a better way?

Hello, I would like to send an SMS or Email as notification when I click on button in Certain Records. But unfortunately buttons are not supported in the Android APP, I wanted to run a script when I press this button in my Android APP. What do you suggest as alternative? Best Regards, Amro

I have created a base that has a list of all my customers. I am looking to embed each individual record e.g. my customer data into another website so my staff can view it. I can’t seem to work out how to embed individual records. Is this possible? If not does anyone have any work around?

I have a great base setup that is then grouped by ‘Month’ and shows all of billing records through the month/year. Month being a single select column. Billing records being a different currency column. On the desktop app and through the browser, I am able to easily see the monthly and full annual total at the top of each ‘group’. On my mobile device, I am only able to see the count at the top of each group. The number of invoices I’ve billed out a month is not my top concern, instead I’d like to see how much I’ve billed that month total. How can I create this on mobile? Is there a separate setting, view, or do I need to create a new base altogether that pulls this data? I have created a pivot table through the app, but again cannot figure out how to show this on mobile.

We have the paid version of Airtable that allows private views to be hidden from others. I am creating views for multiple people and would like to hide each one from those they are not for. For instance, “Jeff’s view” would be available to him and me and hidden to everyone else. From what I’ve seen, a contributor has to create their own personal view in order to hide it from others? One of the biggest complaints from our team in implementing Airtable is that there is too much visually, so I’m creating separate views for each team member and would like to hide the others. Thanks!

I seem to remember this option used to be available but maybe that was only on desktop? It would save a lot of time!

Hi, i amusing private Wi-Fi network but yesterday evening i am not able to open website, app or other app which using airtabel database. if i connect using mobile data its all working very good please help to solve this. Thanks

I’m having a hard time. When I duplicate a table and put a specific filter like “where - your class - is - 1”, it was suppose to appear only the records where the fiel “class is 1” appear. However, when I fill out the form created to feed this database, and put it in the field “class 1”, it just goes to the original database, and it doesn’t go to the other duplicate base but with the filter. I remember this working normally when I had a PRO plan, and now I have a free plan and it is no longer working. Does this problem have to do with the plan?

I select Duplicate Table and toggle on Duplicate Records, but the records are not duplicated. Anyone else have this issue?

Hi Everyone, Does anyone know if there’s a way to format a long-text column to have all the same formatting? I have rich-text enabled and would like all the text to be italicized. I’m hoping I don’t have to manually configure each cell to be italic but can’t figure out a way to do it. Thanks!

Hi, In a base, I have a column called {Launch Date}. I would like create a new column that contains the date X work days before {Launch Date}. I do not know this date in advance and want this new column to generate it! Thanks!

I use the Typeform integration with AirTable but when sending multi-select data where the user has chosen the “other” option and entered a custom value it doesn’t get added to my AirTable. Can anyone help me here?

Hey AT Users. Has anyone come across a good solution for either timestamping an updated element in a field or generating a timestamp for when a computed field contains a value vs when it is empty? For context: In our base there is a rich text field which includes a check list of about 10 items (done to eliminate the need of 10 separate fields, as there is already a LOT of data to process in this base). Using the following formula I can only return a timestamp for when the entire field was modified, not the particular element in that field: IF(FIND(" Milestone “,{Milestones Checklist}),DATETIME_FORMAT(SET_TIMEZONE(LAST_MODIFIED_TIME(), ‘America/Toronto’), ‘M/D/YYYY LT’,”")) If anyone has a work around for either timestamping when each of the 10 elements is marked with an x OR knows a workaround for timestamping a computed field - then I could add an IF(FIND(" Milestone",{Milestones Checklist}),“Yes”,"") field and then timestamp WHEN that yes appears. Any thoughts???

Hi all. New user and still finding my way around. Just signed up for the 3 day mini-extension trial as I want to have a go with the Client Portal Mini-Extension. I’m not techy and have extensively Googled a ‘how to install’ the above but can’t find out how to do it anywhere. If I’m not careful my 3 days will be up before I’ve figured out how to install it. Any help would be greatly appreciated. Thought it would be obvious but can’t see how to add this or any other mini-extension. Many thanks

Hey Guys, I have used a formula that I copied from an answer here to create an end of month field. I have transaction dates for sales and i want to get the end of month date for each transaction date. It works for all months except when a transaction takes place in any december for some reason, in any year. For any other months, it works fine. This is the formula that I am using: DATEADD( DATETIME_PARSE( DATETIME_FORMAT( {TX DATE}, ‘YYYY’ ) & ‘-’ & (VALUE( DATETIME_FORMAT( {TX DATE}, ‘MM’ ) ) + 1) & ‘-01’, ‘YYYY-MM-DD’ ) , -1, ‘day’ ) Can anyone try to pinpoint what’s wrong with it please? Thank you Hady

Is there any way to simplify this: https://airtable.com/shr4JpyGCNxWTqt7S? If I could put the amount of resources by type and quantity in one column it would make this much easier (for the overview table that is).

Hi! Trying to create a menu item that has options that need to be selected at the time of placing the order. The options do not affect the price of the item, but are an indication of which flavors to include. I can’t figure out how to add checkboxes within an item.

I’m fairly new to AirTable and I’m trying to get a peak of all the possibility this tool has to offer. I’m thinking about migrating an app, which is currently configured using a JSON format, to AirTable. The goal is to allow my teammates to see/update the data. Also, I saw there are tons of possibilities with AirTable and I’m also looking for creating forms and user interfaces eventually. Basically, AirTable may replace the backoffice I’m supposed to build. But I have a few questions about how I should proceed, and I hope I can get some advices here! :slightly_smiling_face: JSON to AirTable AirTable doesn’t support JSON format. Therefore, I’ll convert JSON to CSV and then import the CSV into AirTable. But I wonder how I should convert those data to be efficient in AirTable and allow proper usage using JavaScript when fetching the records later on, through the API. Here is my data structure: [ { "state": "active", "name": "name", "label": "Label", "logo": { "ur

Hi Need help with my directory build. Users join my site via Memberstack and name + email is zapped to Airtable (“Memberstack” table) Members are re-directed to dashboard to complete their profile (Airtable form/table “Profile”) I want to automatically push the “Memberstack” table data (name + email) to the “Profile” table and prefill the “Profile” form. The resulting “Profile” table will then get zapped to Webflow CMS Can someone tell me if this is possible and how to do it? I can’t find the right solution as I’m a nocode newb. Thanks