Skip to main content

Solved

7384 Topics
C
cadyellowInspiring
asked in Base Design
Multiple product quantities moving inventory to multiple locations

Hello! I've got an inventory board ("Print Products") that has hundreds of products (each with variable quantities). I add new amounts of each product regularly (in "Order Received" and "Products Received" for individual line items). When I sell items they go in "Order Sold" (with "Products Sold" for individual line items).The problem is, I move various amounts of various products between multiple locations. Sometimes they sell at a location, but sometimes they don't and I need to move unsold inventory around between locations. I created another table "Currently At" to try to keep track of how much inventory was at each location, but I'm finding it incredibly time consuming and tedious to input each quantity one line item at a time so that I can check in/check out the different quantities of each product. I was able to write an automation so that when I put something in "Products Sold" it automatically put it in "Currently At" with the correct quantity decrement. I can make forms

8013
C
K
KGBParticipating Frequently
asked in Formulas
IF AND Formula Help!

Hello!I have two fields that I want to meet certain criteria to return a value in another field.Return Value "Late" if field 1: Advanced Record contains "ADVANCED" and Field 2: If Date/Timestamp is after 10p EST otherwise return "On Time" if Date field is empty have this field stay empty Thanks!

62
K
J
jonaskarlesNew Participant
asked in Interface Designer
Ratio in interface

How can I display a ratio between two values in interface (dashboard)?I have the field "hours" in a base.In the dashboard I want to display the number of hours last week divided in a static number.Like:All records from last week.Total amount of hours from those records.Divided in 8.Plot this on a chart so I can see progress over time. I'm OK to go through a new table in the base to solve the problem

342
J
M
mirkolandoInspiring
asked in Base Design
how to auto assign tasks according to a single select field

Hi Airtable Community,  is there a way to auto assign tasks according to a single select field. I have a single select with multible Teams (CRM, Website, Social Media etc.). I want a new record to be auto assigned to the team lead of the team from the single select field. New records will be created with a form.  Best regardsMirko 

241
TheTimeSavingCo
W
wesamNew Participant
asked in Formulas
using f-string with filterByFormula

Hi,i am using python-requests and trying to use f-string with filterByFormula here is a simple implementation:hard coding the name worked:   url=f"https://api.airtable.com/v0/{base_id}/{table_name}/" headers={'Authorization': f'Bearer {api_key}', 'Content-Type': 'application/json'} query={"filterByFormula":"({full_name}="some name")"} response=requests.get(url, headers=headers, params=query) data=response.json()    but when i tried to use f-string it didn't work. here is a a piece of code where the problem occurred:   url=f"https://api.airtable.com/v0/{base_id}/{table_name}/" headers={'Authorization': f'Bearer {api_key}', 'Content-Type': 'application/json'} employee_name="some name" query={"filterByFormula":f"{{full_name}}={employee_name}"} response=requests.get(url, headers=headers, params=query) data=response.json()   {'error': {'type': 'INVALID_FILTER_BY_FORMULA', 'me

121
W
E
erangggKnown Participant
asked in Automations
email automation send based on user

Hey,I have an automation that when the status changes to "done" an email is sent to the customer.Is it possible to send an email to the customer from the email of the user who changed the status?For example, if I change the status to "done" then an email will be sent to the customer from me, but if someone else from the company changes the status then an email will be sent to the customer from him.

135
Brian_Sweeny
S
slyfoxInspiring
asked in Development & APIs
Scan Multiple Bases

I need to search records in multiple databases and if the search result is not empty then set a variable for that particular organization. I will then compose an email using non empty variables. Scan Airtable A base, if the output is not empty, set the variable Clinic A to results. Scan Airtable B base, if the output is not empty, set the variable Clinic B to results. Compose email that includes non empty variables: Hi John Smith, Please submit the following items: Clinic A variable (has value - not empty) [Clinic B variable is not included as the variable in the previous scenario was empty due to no search results) Can’t figure this one out as Integromat requires everything to go in a flow as I am using filters to filter in or out empty search results. But if search results for variable A are not passed then the rest of the flow does not happen.

92
Lucas_Ravassall
P
Petar_BrkovicNew Participant
asked in Base Design
Is it possible to search across the multiple tables?

Hey guys, I host my own pub quiz and since I’ve done around 80 of them I start forgetting and sometimes I add question I had before. I’m looking to make a database which I’d update after each quiz so I can quickly search for keywords or answers. This tool does seem really useful and I’m willing to explore it. Now I’m curious if I’d be able to somehow search for the answer across all the different quiz tables I make? Thanks for your help! Screenshot_1|690x201

13111
Lucas_Ravassall
J
jdkeenan01Participating Frequently
asked in Base Design
changing long form text alignment

Is there anyway to change the text alignment for long form text to be left justified instead of right.  See screenshot.

102
J
J
jdkeenan01Participating Frequently
asked in Formulas
Formula to replace question mark with an apostrophe in a text field

My text fields imported from excel have a question mark where an apostrophe should be.  Is there a simple formula to correct this?

497
J
M
Miroslav_TunjicInspiring
asked in Base Design
URL Shortener workaround?

We dont have URL shortener? Any free workarounds, formulas, links? Tnx!

1392
SilverTaza
T
Travis_Groom1Participating Frequently
asked in Base Design
Lookup in Forms Based on Data other than Primary Field

Hello AirTable Community,Here's a fun one that I hope I can pick some brains on.  We have a Workday integration that creates an employee directory that feeds quite a few bases. With the Workday integration, we have to use a unique identifier - that being employee ID. However, employee IDs are not regularly used in our company so many do not know theirs. When filling out a form, they would typically use the employee name, which is not the primary field in the Workday integration (because of the unique identifier requirement.)Is there any way, via automation or some other method, to have the linking record be the employee name instead of the employee ID? If not, has anyone made a successful automation that would switch these columns after each sync with the Workday database? This has become quite a big blocker for us, so hoping someone has an idea of how this might be accomplished. 

132
T
E
Erin_AlterInspiring
asked in Interface Designer
Limit the choices for Single Select field in Interface Form

Is it possible to limit the options for a single select field in an interface form? i can definitely do this in a regular airtable form. but i can't seem to figure out the way to do this in an interface form.example: single select fieldOption 1Option 2Option 3Can i make the interface form only offer them the choice of Option 1? or only Option 1 & Option 2, but not display Option 3 as a choice?

713
E
B
Brooke_LutzNew Participant
asked in Formulas
How to pull specific text out of a string that could have multiple formats

I have a URL field that I need to grab specific text from (in bold). Does anyone know if there is a formula I could use to easily grab just the string in bold without pulling in additional data from the 3 possible formats?Here are the multiple formats that the URL could be in:Sample format 1:https://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9ASample format 2: includes ?ABC=1 at the end https://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9A?ABC=1 Sample format 3: includes 2 URLs only separated by a spacehttps://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9A ABC: https://www.website.com/en/others/A1087A50-AB73-48AA-B056-A3A472711A9A?ABC=1Sincere thank you in advance for anyone who takes the time to look into this and provide any suggestions!

102
B
J
JD11New Participant
asked in Other Questions
Getting photos to populate from a URL

Hoping someone can help me.  I'm sorry if this is not in the correct section.  I'm new to this and not sure of what to call most things.   I'm a crafter and i'm trying to use Airtable to keep an inventory of my craft supplies.  I have imported data from a different system, and have titled the column that contains the URLs for the photos  as "Image" and defined it as URL.  However, i can't get the images to populate.  I wrote an email to airtable asking for help, and although i keep replying to emails saying they're busy, with i want to wait, it's been well over a month and i still don't have a response.  I have tried looking up on the internet in various places, and have found issues the same as mine.  However, the fixes they show apparently are from a different version of airtable than is currently available, as many of the screens they show have different options from what I see, and i have not been able to equate the old to the new t

121211
TheTimeSavingCo
A
AcDemasNew Participant
asked in Formulas
Formula to identify diacritics

Hello,I am working on a base that includes artists' names and a lot of them have diacritics in their first and last name. Is there a formula that I can use that could identify if there are diacritics used? It can be a simple True or False formula that I can then use a filter to isolate everyone with diacritics in their name. For First and Last name I am used simple Single line columns.A list of names is important because it is used for a remapping feature on our website, so the end result for airtable needs to be a filtered view of names. I appreciate any help you can provide with this. 

92
j-hugg-ins
R
Really_ReallyRuNew Participant
asked in Other Questions
How do I automatically generate a name

I have a single line text field as a primary key “name” field. if it is blank when I save the record, I would like to automatically fill in the name as a concatenation of three other fields that are in the record. How can I do this?

972
A
D
Daniel_RobbinsKnown Participant
asked in Other Questions
Random number functions

Perhaps I’m missing it, but how do I generate random numbers? I am missing “randbetween” and “rnd” from Excel. Thanks for any and all help.

72239
hello_ipsally
Sean_Murphy1
Sean_Murphy1Inspiring
asked in Interface Designer
Conditionally shown fields in interfaces?

I’m curious if there are any plans to add conditionally shown fields to Interfaces, similar to what is possible in form view? For example, if you’re tracking network outages you might use one field to specify that the cause is a power outage, in which case you would want other fields to appear that let you specify when the power outage started and ended (so you can track UPS runtime when the power goes out, and site recovery time when it comes back.)

31117
S
J
Jeanette_SegubaNew Participant
asked in Interface Designer
How to delete published interface?

I’ve been trying to delete a published interface but can’t find where to delete it. I opened the interface and looked for a delete button but couldn’t find one. I exited the interface and went to my workspace to see all of the bases and interfaces I have, but I couldn’t find an option to delete it there. Thank you in advance.

34412
C
S
Sara11Inspiring
asked in Interface Designer
How show an interface without airtable account?

Hi, I'm playing with the interfaces and I have a question. Is there any way I can share an interface with a person that hasn't an Airtable account?I don't want to add them as collaborators, because they should see only that interface (not the base) and I don't want to ask them to create an Airtable account just to see my interface. My final goal is sharing the interface link with an automation through email. Is there any way? Thank you!

18941
M
madisenbaldwin
madisenbaldwinKnown Participant
asked in Enterprise Network
Random Features I'd like to see in the future

Hi all! I thought I would share some things I wish I could do on Airtable right now, manifesting that they may be future features.1. In a long text field, I wish I could use bullets and hyper links. This would help display cleaner for the field in interfaces2. I wish I could save a record as a PDF from an interface - from the record selector and single record layouts. I know this can be done in Page designer extension but - to my knowledge - page designer does not dynamically space. And its not nearly as easy to customized as an interface.

144
madisenbaldwin
A
Abigail0102Known Participant
asked in Formulas
Using nested IF test with AND tests stacked for multiple criteria in one column

Hello!I am trying to create a formula that categorises ships by type, then size category, and if they meet both of those criteria they are assigned a value that is annual fuel consumption appropriate for the vessel's size category. If not, the IF test continues through all size categories and finally ends on "NA" if nothing it true. I would have thought I would be able to nest like the below example, but for some reason it only generates the correct answer for the first two size categories, then everything higher in size gets the same second highest fuel value:IF(AND({VESSEL TYPE} = "SHIP TYPE1" , {SIZE CATEGORY}<=1000),"XX Fuel consumption value",IF(AND({VESSEL TYPE} = "SHIP TYPE1" , {SIZE CATEGORY}>=1000<=1999),"XX Fuel consumption value",IF(AND({VESSEL TYPE} = "SHIP TYPE1" , {SIZE CATEGORY}>=2000<=2999),"XX Fuel consumption value","NA")))Below is the actual formula if that helps anyone understand. I also hoped to be able to have all vessel types an

72
A
C
cshenoy86Inspiring
asked in Automations
Automations Disabled on List Interface

I have an interface in a list form.  I added a button to the interface. I want the user to be able to select multiple records from the list and click on submit. However I see that the button is disabled and it does not detect the source. I tried adding a dummy record picker element at the top and I could then see the button. But my question is I should not have to add that dummy element because I just don't need it on my interface page. It just creates a lot of confusion for the user to see that dropdown. Is there a resolution for this? Do automations only run when there are record pickers in the interface? Because that is pretty weird according to me. 

152
C
S
swtaniParticipating Frequently
asked in Automations
Error on second action when trying to update a change a field used in the trigger

I am learning automations and I have hit an error I cannot figure out.There are two tables involved in this automation:People table where the client master data residesClient Funding table where clients' stipends and grants get recordedHere is the logic I am trying to make happen:When Client Funding Indicator field changes to "MicroGrant Invited", do two thingsCreate a new Client Funding record for the client <-- This step works correctlyReset the Client Funding Indicator field to "Funding Not Specified" <-- This step gives me the error "Received invalid inputs."Thank you!!!

12
S

Badge winners

Show all badges
Terms & Conditions