Solved

I am currently trying to get by without a dedicated TIME field with no date attached. I am currently trying to convert a text field into a timefield with the following code: DATETIME_FORMAT(DATETIME_PARSE({Start Time}, ‘hh:mm’), ‘hh:mm a’) The focumula is working fine, however when I write in a time, such as 3pm, it still parses it in as 3am. I note that if I put in 1500, it correctly parses the time to 3pm. I have worked in systems where you could put in variations of (3pm, 3p, 300pm, etc) and it would always know that meant PM. Is there a way to make airtable do this, and of course the converse with AM, so that I do not have to use military time?

Hi all! I have two fields, both filled with features. I want to see which features are repeated in both fields. For example, I want a column that would tell me that ‘Feature2’ is in both columns of row 1 (record1), Feature3 and Feature4 are both in the columns of record 2 and 'Feature1 and Feature3 are also both there in record 3. Maybe a formula like: If the text in column A is similar to the text in column B, then insert it in column C? I hope this is clear! Thanks in advance for your help!

Hello! I have built a database to record a patient’s treatment. I have shared with him a form to introduce the pills he takes… .but I still have to add up the number of tablets he takes in a day, a week or a month…. I have tried with sum and rollup formulas … BUT I DON’T KNOW HOW TO DO IT! Could you help me get it? What steps should I follow…. What can you think of? I could even share my database with some of you to help me make this column, sum, sum or rollup…. THANKS A LOT.

In the image you can see it pulling in the whole record (2020 Sweden), But I actually only want to display a single field from that record. Is it possible to do this?

Hello all! I have been losing my mind for 4 hours on this ‘simple’ task I am trying to implement in my base. I want to automatically update several fields (example : set Phase to ‘Initiation’) when a new record is created. I am able to update all required fields with Zapier. My problem is I am unable to use the ‘Find record’ feature to update the last entry. It would be easy to fix if I was able to simply ‘Find record’ when ‘Field x is empty’ or ‘Find record’ when ‘Auto update for Zapier… = Created’… I don’t understand why I keep getting an error on Zapier… this field exists with only 1 entry set to ‘Created’… and this is the entry I want to update.

Hi all - we’re testing out Airtable and really like it, but I have a question. We have two tables in our test. Once contains company data (name, address, etc.). The other contains financial data that would be updated on a monthly basis from a secondary source. We’d basically upload updated data from a CSV file on a monthly basis. How do I update the field in the first table with updated/related records added to the second table after I upload the CSV?

This is admittedly an aesthetic concern, but I feel like it should be possible. I have a formula that tests a checkbox field, {Guild?}, to see if I owe fees for a given project to a guild I work with. If it is a guild project, then the formula should return a currency value equal to the amount received for the project, {Rec’d}, times the Cut field, which is a percentage. Currently, I have it written like so: IF({Guild?}=1, {Rec’d}*{Cut}, " ") This returns the right numbers for guild projects and leaves non-guild projects blank. Fine and good. However, I cannot use the field formatting options because the values are not all numbers. Is there a way to tell Airtable to return {Rec’d}*{Cut} as currency?

I am extracting a database of children’s books via Airtable API. This is my code so far(hiding my API KEY). It renders every book, but in a random order. I want to sort them by year. I am trying to follow the documentation from Airtable, which demonstrates the code to sort by multiple fields. I don’t really know where to place this code in my original code, and how to adapt it. Thanks for your help! import Hero from '../components/Hero'; class News extends Component { constructor(props) { super(props); this.state = { books: [], }; } componentDidMount() { fetch('https://api.airtable.com/v0/appYI3FvXw9Isfvj7/Favorites?api_key=API_KEY') .then((resp) => resp.json()) .then(data => { this.setState({ books: data.records }); }).catch(err => { // Error :( }); } render() { return ( <><Hero title="Children's Books"/> <div className="container mt-5"> <div className="row">

Hello everyone! This being my first posted question, please let me know if I haven’t provided enough information / context, or if this question is being asked in the wrong Category. This will help improve the way I phrase the question as well as where to address it. I am looking into Zapier, using it to automatically create a record, and when creating this record automatically filling in some of the data. Most of it is pretty straightforward, but I can’t figure out yet how to instruct Zapier to automatically check some of the checkboxes in the row / record. If anyone either knows the answer, or knows where I can find the answer, that would be great! If this question has been asked previously, I checked for an answer but I could have missed it, I will remove this question so that things will stay organised. Thanks in advance, Gunnar

I have been trying the Miro block, but so far I cannot get any rows / Miro shapes to update. The announcement has a GIF that makes it seem so, but is this even interactive?

Hi! I would like to use Airtable to do my accounting, but I need a formula that is way above my paygrade, maybe someone here can help? I have a (single select) column 'deposit/withdrawals" and an amount column where all amounts are positive. I’d like to have the withdrawal amounts show as negative. So I made a third column where I’d like to say “if column 1 says withdrawal, then please give me column 2 amount as -amount, if it says deposit, then please give me column 2 as +amount”. Maybe that’s not the right way to go (?) but in any case, I’d love some help if possible! Thank you!

Hey guys. Is there any way to add something like a button? Take a look at Field30:

Ok this seems like it should be simple but I can’t figure out how to just cut and paste multiple records. It always overwrites the existing data rather than creating new records. Super frustrating considering how tedious it is to enter data manually into Airtable! What am I doing wrong?

I have a view which is grouped by project name in order to show total time spent per project. My options for sorting the groups are alphabetical. I would prefer to sort this group by a date field so that it shows the most recent project at the top of the screen. Is this possible? I was able to create a formula “Date” & “Project” field which was successful, but it’s not a particularly clean way to go about it. Thanks!

Hey there! I normally post as @Saastronomical But I can’t log-into my Community account as of this morning. I get the following message: “There is a problem with your account. Please contact the site’s administrator” Any ideas of who I can speak to to get re-instated. Can’t think of any reason I wouldn’t be able to log-in. Any help would be appreciated! Cleared all cookies/cache many many times now, and still no luck - Would appreciate any help!

Hi ! I’m searching since days the solution on the forum, i just can’t find it, but it might be really easy ! I have two tables, in one of them i have all the informations i need, and in the other i would like to have a general view of my data, and organize it. For example, i have a column with a single select, and i would like to retrieve in the other table, only the records that have the “Yes” option. In the second table where i want to retrieve the data, i already created a link to the first table, to count afterwards, but it doesn’t work … Any idea ? In general, i want to retrieve certain data from a table depending on specific criteria, to another one.

How many tabs on the top is “too many”? How do you work out what to add to a table and what to bring to a different table. For example, I am tracking clients and behaviors. I want to create customized behavior goals and bill for their services (and eventually other things). Right now I have: Table 1: Client Information (names of kids) Table 2: Contact Information (parents, foster providers, case workers, team members of the kids, linked to their kid) Table 3: Notes that I write about each visit Table 4: My invoices (linking to the start/end day and time, duration generated in Table 3) Table 5: Goals, behavior tracking I guess my question is should table 5 be on it’s own, or should this be consolidated in “client information”? What is the benefit of having Table 5 house behavior tracking (linked to Table 1) vs. having a separate view in Table 1?

Hi all, I am a free user and I´ve been sharing a few bases with other free users for a while. I am thinking of upgrading my account to a paid subscription, but I am afraid this might affect collaboration with non paid users. How does this work? If this sort of collaboration is possible what happens to the product features available only for paid subscriptors when working on a shared base? Thanks!

I saw a post with the following formula: IF(IS_BEFORE({Due Date}, TODAY()), “ :boom: ”, " ") This formula puts the emoji in a column if the due date for something is past. I’m not really good with formulas. Is there a way to make it have that emoji if it is ON the due date AND after?

Hello, I have a table and need to assign a price depending on the status AND the Language: {Status} = Confirmed & {Language} = Spanish Then $95 {Status} = Zoom & {Language} = Spanish then $85 {Status} = cxl on time then $0 {Status} = Late cxl & {Language} = Spanish then $95 {Status} = Zoom & {Language} = X-Exotic then $115 {Status} = Confirmed & {Language} = X-Exotic then $150 {Status} = No Show & Zoom & {Language} = Spanish Then $95 {Status} = No Show & Zoom & {Language} = Exotic Then $115 Thanks in advance!

Hi there, I’ve been working on this and cannot seem to figure it out. I’m trying to write a conditional IF statements that essentially says - IF Field A= 1 and Field B=2- output 3 IF Field B=1 and Field A=2- output 4 IF Field C = X- Output X Here is the current syntax I have written- I’ve gotten it to do the first two parts, but cant get the last part running. Any help is wildly appreciated!! IF(AND({Are you in recovery for a mental health disorder?}=‘Yes’,{Are you in recovery from a substance use disorder?}=‘No’),‘MH’,IF(AND({Are you in recovery from a substance use disorder?}=‘Yes’,{Are you in recovery for a mental health disorder?}=‘No’),‘SUD’),IF {Field 60}=’CO’,’Co’,’Z’)

Hi. Is there any way, programmatically or by some setting (either on block or on the dashboard) to change the height of the block within the dashboard? No matter how many blocks are displayed in the dashboard, each of them seams to be 304px tall (including its heading). So even if there’s just one block, there’s a lot of unused whitespace while at the same time the block would be able to display more data. Our custom block displays a lot of content within an iframe, it expands the iframe to occupy as much space as available. But since the height of the block is fixed, it’s rather limited (read “very small”). I know the user can switch the block to the fullscreen, but that doesn’t help as that covers the data in the table, so when the user wants the block to react to cursor change (which is the coolest think and the only reason to use the block in our case), they need to exit the fullscreen, select another record in the table and then either scroll within the block or enter the full scr

Does Airtable offer view of family tree. i.e say I want to know all the family members of my uncle, does it come in one page. ( earlier I would have put the details of uncle and all his family members in separate rows- so is there a feature to connect them and then retrieve the family in one page) . It would come to use when I meet my uncle , I want to recollect all his family members names and birthdays, etc

Has anyone retrieved data from multiple tables via the api? I can retrieve one set from one table no problem and I know how to to do this in SQL for muliple inner or outer joins but I have a little bit of a block doing this in node.js using the api. Thank you

how to return the values ​​of a related table, not the key, I try to do this from the javascrip api, what i have is this: const response = await airtablePlanes.list(); and he answers me: [ { “id”:“recJhPPsonGK6WQiO”, “fields”:{ “valor_mensual”:4569, “Name”:“PLAN_4”, “planesToCoberturas”:[ “recGBXvrvXt6KhatT”, “reckjMfRzp6jnHEED”, “recCFBaAfBirzw6V3”, “recg1TjYd6ekRHXqJ”, “recM04lVdWj2CDIeI” ], “descripcion”:"Plan 4 ", “valor_anual”:54825 }, “createdTime”:“2020-04-08T22:25:48.000Z” }, { “id”:“recZQkZ6hI62FqvJ0”, “fields”:{ “valor_mensual”:1286, “Name”:“PLAN_1”, “planesToCoberturas”:[ “reczIR8pPZBAJdSsM”, “recH0CU0TqA9cfiFg”, “receQ9xxWZqrtd2V9”, “recG7E3gux8diAm2D”, “recSsWKkZTCda0kab” ], “descripcion”:“Plan 1”, “valor_anual”:15431, “registros”:[ “recovGEbYXVD3ISb3” ] }, “createdTime”:“2020-04-08T22:24:27.000Z” }, { “id”:“recpDt0xL5yDPcrec”, “fields”:{ “valor_mensual”:2380, “Name”:“PLAN_2”, “planesToCoberturas”:[ “rec9zIsScaSyFwTc0”, “recRFqypir5CyMG9z”, “recNIguFd32J9H5ma”, “recDNT4YUm