Solved

Hi Guys, We’ve freshly setup awesome initiative for Tech companies that want to help NGOs, we are getting many responses and submitions but not all of them are Tech Companies that we are look for. TechToTheRescue[dot]org there you can see our We have Live view for Grid on embeed on website + form under this. I want to have option to approve form submission before it goes live, is there such a option? Best, Tom

Hello, Is it possible for a good soul to fly to my rescue please? I wish to apply the following script on my base with the constraint that the calcul must be reset each time I pass on a new groupfield. Being a novice I don’t see how to modify my script to apply this constraint. The script I use is: let table = base.getTable(‘Data’); let view = table.getView(‘Grid view’); let result = await view.selectRecordsAsync({ sorts: [ {field: ‘Identifiant Fournisseur’}, ] }); let runningTotal = 0; for (let record of result.records) { runningTotal += record.getCellValue(‘Quantité Collectée’); await table.updateRecordAsync(record, { ‘Test’: runningTotal, }); }

My local grocer store is being overwhelmed with email orders due to Corona-19 created demand. Is there a template already that would allow customers to order online for products that would come under a range of Meat, Veg, Fruit, etc

Is there an ability to give outside access or sub-admin access to specified cells or information on a database spreadsheet resulted from form inputs? For instance, It would be awesome if someone could just see ‘Portland’ associated submissions on the back end based on that cells data. (being portland)

I created a table. Then I created multiple grid views (with various filters and sorts on them). Now I need to add a new field (column) and I want it to show up on all the grid views. So far, I can only get it to show on the one I add it to. Thanks for your help!

Dear Airtablers, I fully accept that I might be working non-intuitively, and am looking for help and suggestions. I‘m attempting to keep my accounts under control and wish to flag up the 4 possible statuses I can conceive - either an invoice is „Paid on time“, „Paid late“, „Open“ (unpaid but not yet late) or the worst kind „Unpaid and late“. As a beginner I‘m having terrible trouble but not much fun finding out how to do it. I have the following fields: Date invoice sent Terms in days Due date (automatically generated from formula) Date paid (blank if open) Pay cycle (in how many days did my client pay?) Days late Punctual/late/unpaid? What I (think I) want: In „days late“, I want to show 3 things. Invoice on time (thumbs up) Invoice late and unpaid (exclamation mark and number of late days) Invoice late and paid (alarm clock and number of days late) So far I managed: IF({Pay cycle in days} >14, DATETIME_DIFF({Date paid},{Due date},"days")) How do I nest the next two settings,

Hello, I have a table that rolls up sums from two other tables and displays them in currency format. My hope and expectation is for these values to match, and if they do not, the record is flagged. I figured this would be a simple IF function that looks something like this: IF({Rollup 1}={Rollup 2},“ :white_check_mark: ”,“ :x: ”) The result is what is confusing me. I find that even if the two rolled up values match with an eye test, they might still be flagged as being unequal, I’ve tried changing the formatting and expanding out the number to see if it has to do with some hidden decimal but have had no luck. By all appearances, the numbers match exactly. I’m not sure if this has something to do with how the records in the linked tables are formatted either but figured that if the field being rolled up is in the same format, this shouldn’t matter either. Chances are that I’m missing something incredibly simple but if anyone has any advice on why this is happening and how I can get a pr

Hi community, I’m trying to create a grid view with groups like the below, based on an ‘Event Date’ field: share.getcloudapp.com – 20 Mar 20 Screenshot 2020-03-20 at 14.17.51.png Shared with CloudApp Year Formula: IF({Event Date}=BLANK(),"Date Missing",DATETIME_FORMAT({Event Date},'YYYY')) Month Formula IF({Event Date}=BLANK(),"Date Missing",DATETIME_FORMAT({Event Date},'MMMM')) Why is April coming before March? How do I fix this so that months are sorted in sequential order (eg March -> April -> May)? Many thanks in advance! Let me know if you need any other information from me on this.

Hi. I’m writing a novel with TONS of ideas, notes, characters, themes, etc. Any recommendations about how to use Airtable to organize all of this? Any examples of this that I can take a look at? Thanks! LAWRENCE

Hey there, In order to better manage my emailing campaigns and some of the auto replies I’m receiving I integrated my sending box with Airtable. To ease the cleaning I would like to add within a column a specific code based on the corpus of the auto reply. Here is an example of the formula I came up with: IF(SEARCH(“yyyy”,Corpus),“Click to validate”,IF(SEARCH(“XXXX”,Corpus),“Nothing”,IF(SEARCH(“aaaa”,Corpus),“Nothing”,IF(SEARCH(“bbb”,Corpus),“Nothing”,IF(SEARCH(“ccc”,Corpus),“Nothing”,IF(SEARCH(“ddd”,Corpus),“Unsubscribe & Check for address”,IF(SEARCH(“eeee”,Corpus),“Unsubscribe & Check for address”,IF(SEARCH(“fff”,Corpus),“Unsubscribe”,IF(SEARCH(“gggg”,Corpus),“Unsubscribe”,IF(SEARCH(“hhhh”,Corpus),“Unsubscribe”,IF(SEARCH(“iii”,Corpus),“Unsubscribe”,IF(SEARCH(“jjj”,Corpus),“Unsubscribe”,IF(SEARCH(“kkkk”,Corpus),“Click to validate”,))))))))))))) but it doesn’t seem to be working. Do you guys have any clue why? I may have to add new criteria moving forward. Thanks a lot in advan

Hi. If i pay for two users can I at any stage change who one or both of the users are? As long as I only have two users, does it matter who they are - ie are the fees attached to the number of users, not the individuals?

I feel like what I’m trying to do is simple, but I just can’t make it work. I want to remove the text in the brackets. Example below: [SUPV PROD - STAFF] Doe, John [SrDesign/Ani - FL] Doe, Alice [PRO/EDITOR - Ani] Smith, David I want to remove the all the text in the bracket and the brackets themselves. Desired results below: Doe, John Doe, Alice Smith, David The Bracketed text is always in the beginning of the string. Thanks!

I can’t seem to figure out this formula. Here is what I would like to do. Compares today’s date with a specific field date. If today’s date is after field date I want to multiple field A by 10. If today’s date is before field date, then I want to multiple field A by 50. Regardless of which calculation is done above, if the sum of the calculation is 1000 or above, then I want 1000 returned instead. For example, let’s say field A has a value of 50. If today’s date is after the field date, then the value returned would be 500. If however, today’s date was before the field date, then the value returned would be 1000 (even though the calculation would by 50 x 50 = 2500, the 1000 limit would override it). For the life of me, I can’t figure this out. Can anyone help?

Hi all, Is there a way to sum the number of years passed (as a whole number, rounded down) from a listed date to present? I’m using this for an asset register. There are 4 important columns: A) date of purchase B) original purchase value C) annual depreciation (as a %) D) current value I’m looking to write a formula for current value (D) that will multiply the annual deprectiation % © by the number of years that has passed since the date of purchase (years since A), then multiply that by the original purchase value (B). For example, if 3 years have passed since purchase date, the original price purchase value was $1,000, and the depreciation is 16.67%, it would be ((3*.1667)*1,000), returning a current value of $500.10. How do I get that 3 to caclucate automatically in a formula?

So I know this shouldn’t be all that difficult, and I get the results for my first two outcomes (Blank and 1 Year), but no years past Year 1 provide an answer. IF({Last Service Date}=BLANK(),BLANK(),IF({Service Frequency}=“1 Year”,DATEADD({Last Service Date}, 365, ‘days’,IF({Service Frequency}=“1.5 Years”,DATEADD({Last Service Date}, 547, ‘days’,IF({Service Frequency}=“2 Years”,DATEADD({Last Service Date}, 730, ‘days’, IF({Service Frequency}=“3 Years”,DATEADD({Last Service Date}, 1095, ‘days’, IF({Service Frequency}=“4 Years”,DATEADD({Last Service Date}, 11460, ‘days’))))))))))) “Last Service Date” is a Calendar Type and “Service Frequency” is a Single Select Type (Single Line Text had same result). In Excel I can use a different formula that works just fine, but is not recognized here

We have two columns that we need added to a third sum column. Our first column is our Admit Date for people using our program and the second is Exit Date for when they leave the program. We need our Admit Date and Exit Date columns to populate to a total days in care. Right now we have the formula as: SUM({Exit Date}-{Admit Date}) but it is giving us a message of NaN when an admit and exit date are plugged in.

I have a formula for calculating when I can plant seeds, according to the LFD (last frost date), which is and will remain 3/29/2020. Weeks is how many weeks before the LFD I can plant the seeds. The formula: DATEADD({LFD},-{Weeks Start},‘weeks’) Currently I have a whole column for LFD that is set to autofill 3/29/2020 into every row, of which I have 350+. Instead of this whole column for LFD, is there a way I can somehow reference this number one time within a formula, or within one cell somewhere instead of a column of 350 rows with the same number?

I have a formula to calculate how many plants I can fit in a 10x12" square. My formula goes: 10/Spacing * 12/Spacing. (Spacing is a column where I record the number of inches of distance a plant needs). The formula works, except for in two instances- 1. When I have not filled out the spacing column yet, the formula produces ‘INFINITY’ as the result. I’d like it to return a blank field instead of returning ‘INFINITY’. 2. When the plant requires two 10x12" squares (i.e. when the Spacing is 24"), the formula produces 0. I would like that changed to 2, or even better, an actual calculation with a decimal, like 1.5, 2.5, etc. Can anyone help? I’ve searched similar issues but can’t find anything that helps me.

As many would of done, I got the email today regarding scripting. I cant do the webinar due to it being 6am on a Saturday here in Australia but before I spend to much time researching this can scripts work off a submitted form to automatically create links to other tabs? We currently have this as manual process on our Real Estate base where a form is submitted with property details etc. We then have to manually copy the property address and put in in upto 2 new columns depending on a status column. This allows the linking and lookups created to work on other tabs. If not, thats fine, just thought I would ask because this would help us immensely in automating stuff!

I have a song database and I want to keep track of every date I’ve used/played each song, essentially a playlist. Ideally this would be a list of dates listed from newest to oldest. Any suggestions as to how to do this?

I am a researcher, I’ve set up my base so one table has data about my interviewees and the other table has the feedback I’ve gathered from the interviewees. I need to correlate between the feedback and categories in the interviewee table.

Dear community I am trying to add colour to a bunch of records, however, I do not want the colours to be linked to the content of the record. I wonder if there is a way to manually add colour to groups of records, so that not all records that have the same text have the same colour. Is there a way to do this? Best, T

I have images inserted as one of the fields on grid view, is there a way to bring them to show on calendar view as well?

Hey, So I’m trying to achieve a reservations / booking calendar type thing for a hostel. I have set up everything I need apart from the last part. I need to be able to see each rooms availability plotted across a calendar or chart, I achieved it in excel as per the screenshot below: I thought I would be able to achieve it with a pivot table but I have had no luck. I love the way airtable works so it would be great if anyone had any ideas or suggestions as to how I could achieve this! Thanks, Mark

Is it possible to convert integer values into ASCII characters in Formula columns? Pseudo code example: convertToChar(71) returns the char ‘G’.