Solved

Hi, as the title says, is it possible to remove the stickiness of primary tables while scrolling horizontally? It’s irritating because sometimes a field that’s hidden behind it seems to be having a blank title while it’s only hidden. So is there a way? I didn’t find the option to when I right clicked on it. TYIA.

Progressing with Javascript and airtable, was distracted with the thought - can I gear a scripting app button to open a link? I know I that the button fields can open links within a base (but annoyingly their labels can’t be configured on a per record basis). The below simply posts the selected link in the output, but is there a method that allows to open directly into a new tab upon clicking the button? let button_test = await input.buttonsAsync( "abc this is a test", [ {label: 'Google', value: 'https://google.com'}, {label: 'Bing', value: 'https://bing.com', variant: 'primary'}, {label: 'Yahoo', value: 'https://ask.com', variant: 'secondary'}, {label: 'DuckDuckGo', value: 'https://duckduckgo.com', variant: 'danger'} ] ) output.markdown(`### Link: ${button_test} `) output.inspect(button_test)

Hey all! I’m stumped. I have a “Link to” column compiling every testing date, then a “Most Recent Test Date” rollup column using MAX (VALUES) to list back what the most recent date is. However, sometimes we schedule testing dates in advance. HOW do I get a column to determine what the most recent testing date is before TODAY? Thanks so much!!!

{Business User Value} + {Time Criticality} +{Risk Reduction - Opportunity Enablement} / {Story Point Estimate} The first part works great then I add the / and error its nothing to do with the format of the fields as {Story Point Estimate} + {Business User Value} works fine… any ideas? its seem really odd to me

Hi there, I’m using airtable to compare an actual quantity with a goal quantity, then using an If, Then statement to tell me whether I’m at my goal, need to increase, or need to decrease my actual. Here’s my current formula: IF({% of total}={Goal % of total}, "OK", IF({% of total}>{Goal % of total}, "Trim", "Expand")) This is working fine, but what I would really like is if I were able to specify a range for values that are “close enough” to the goal. For example if {% of total} is plus or minus 0.5 of the goal, I want it to return OK. Anyone have any thoughts on how to do this? Thanks in advance!

Pretty much what the title says. We have a role in the company that is going to be split. One of the users / accounts was given “Creator” status, and we need to change it back to “Editor”. I’ve done that, but the account can still do all of the things that a Creator can do. Is there a known issue about this problem?

This is a tough one to describe in one sentence. Basically, I have a group of people who “sponsor” one another. There is no real hierarchy. Person A could sponsor Person B who could sponsor Person C who could Sponsor Person A. Some Sponsors might have multiple Sponsees. So I have one field, “Name”, and another Field “Their Sponsor” that links to the Name field. So I can see each Sponsee’s Sponsor, and what I would like is a way to see each Sponsor’s Sponsees, ideally in the same table. And, ideally, when the field “Their Sponsor” is updated, the “Sponsor’s Sponsees” field is automatically updated. Thanks in advance.

Hello, I duplicated a form and added new questions. The new answers are not showing up on the original grid view. What am I doing wrong? All the best, Greg

I am having trouble with the second IF part of this formula, it doesn’t return any results. I also tried it on it’s own and it still doesn’t return a result. IF({Writer Owned (adds up to 100%)}=.33330, VALUE(“16.66”), IF({Writer Owned (adds up to 100%)}=.33340, VALUE(“16.68”)))

I have a formula field that takes 2 datetime fields and creates a “week overview” with them. But value of [Day] 11:59pm in the End Date field seems to round the day up to the next day, which is misleading. Here’s the formula IF(Start,IF(End,CONCATENATE(DATETIME_FORMAT(Start,"YYYY MM/DD")," - ",DATETIME_FORMAT(End,"MM/DD")," ",{Use Case}),"TBD"),"TBD") Result

Earlier today I responded to a question from a new user here, explaining how she could hide a field on a locked view and keep the field hidden from non-creator users by making it visible only on a personal view configured by the creator. I then had to add that this is security theater (I think that’s the phrase we use these days) because in truth, any user with editor or commenter privileges can simply duplicate the locked view as a new personal view, which they can then configure to their heart’s content–including making visible the fields that the base creator wanted hidden. After posting my response, I began to feel uneasy, so I looked into this a little more deeply than I have before, and I’m a bit disappointed by what I’ve found. I’m praying someone here tells me that I didn’t look deep enough–that there are better answers to my concerns. But at the moment it appears that base creators have only a very limited, casual sort of control over who gets into their bases. . Nightmares Co

Hello Everyone, I have tried watching some videos to no avail… I have a CRM base with many tables. One is [Leads] which I populate with as many different fields as possible to qualify the company. Since I take the time to populate many fields, I then dig into the company and decide if I want to pass them along to sales but I do not want to loose the history of companies I have researched. So I have a pass/fail check box field that is filtered so only the pass appear in that view. I have this table linked with [Sales] so they can enter into the linked field and simply “pull in” leads from the [Leads] table from the + POP Up window. What I would like to have happen is when the sales team brings that record into the [Sales] table it “disappears” from the [Leads] table so it is no longer available. I would prefer an updated field action in the leads record so it can be filtered out of view! I have run a successful TRIGGER in the [Sales] table view by using (when record enters view) or (whe

Hello! I’m trying to merge the data from 2 separate fields whenever they are updated into another field to keep a history of those changes. The first field is date and time, the second field is a single select of location. Ideally, this information would just automatically copy to the next line down of a long text field whenever it’s changed. I have no idea the best way to go about this. Thanks for your help in advance!

Hello All, I have the following script that I use to create links between tables based on the “ID,” which is consistent between the two tables. Typically, I run this script manually every few days or so, but I have recently discovered the “Run a Script” automation, which would completely eliminate the need for manually clicking the “Run Script” button. However, the following script throws an error every time I test the automation (which is when a new record in the “Enrollment” table is created, the script is supposed to run). I’ve gathered that this is an issue with certain functions not being recognized in the automation, however I do not know how to fix this. Any help would be greatly appreciated! //Define the Facilities table and query var facTbl = base.getTable(“Facilities”); var facQuery = await facTbl.selectRecordsAsync(); //Define Enrollment table and query var conTbl = base.getTable(“Enrollment”); var conQuery = await conTbl.selectRecordsAsync(); // Create an updates array let

Hi All, Im not sure if this has been asked before. I tried searching for it but could not find a solution. So here it goes. Im trying to do a simple recurring monthly subscription record. For Example: John is billed every 13th of the month. On his record there is a checkbox, bill date and next bill date. The next billdate is a formula that adds 30 days from the bill date. I have created a view called Monthly. When John makes a payment, the check box will be checked and it will appear on the monthly view. I wanted to uncheck this boc 7 days before the next bill date and how do I update the next bill date so it would add 30 days everytime? Any suggestions?

I have a projects table where I link multiple records from a resources table. The linked records (resources) have different attributes (e.g. aaa, bbb, ccc, ddd) that come from a “single-select” field. My challenge now is to find projects where resources of a special attribute (e.g. bbb) are linked. Is there a function/formula field I could use to color records in my view? I’m not the full Expert on automation or formulas, but I think of a formula that goes to the link of the record, looks for the attribute, and then makes it possible to color or maybe write a “true/false” to another field and I color/filter/group for that. Currently the only solution I could find is to separate the resource-link field into a "link “bbb” resources here (links based on a filtered view) and all other resources on another field. Thus I see in a coulum quickly if a resource with the attribute “bbb” is linked. I don’t like this approach as I want to have all resources linked to a project in one field. It wou

4 columns to do this Shipping Method - single select: boat, shipping Payment Received - checkbox Date of payment - date modified linked to payment received Estimated Delivery Date - formula. I want to write an if statement. This is what I have so far but I’m not sure how to write the second if statement IF(Shipping=“boat”,DATEADD({Date Quoted},52,‘days’),DATEADD({Date Quoted},21,‘days’)) I would like to know how to write is so that is when payment is received estimate delivery is from payment date if date modified is blank then from today boat +52days if flight +21days if date modified is not blank then from date modified boat +52days if flight +21days

The URL to attachment script has stopped working for me completely. It seemingly add files from URLs at first, but then, a few seconds later, deletes all attachments. This alarmingly also happens when I use automations to add attachments from URLs Both of these methods have worked perfectly fine all other times I’ve needed it.

Hello! I am trying to figure out how to apply a unique ID when entering a form so you can see where it was clicked from. I have a store where each row in Airtable posts a new object for sale. I want the ‘purchase item’ button to lead to a form where they can fill in all their information but I can’t figure out how to assign some sort of unique ID so that I can correlate the item they want to buy to the information they put into the form. Is anything like this achievable or is there any advice? Thanks so much for anything and everything!

Hello community! I have streetdance school and this year im doing database with airtable (amazing next to the numbers :slightly_smiling_face: ). Id like to put price for each member of my school. I have collumn with multiple selection (for ex.: streetdance, breakdance, contemporary) and for each course is different payment. Is possilbe to put pricetag for every selection and if i choose any of styles there would be amount of payment. if streetdance would be $40, breaking $50, contemporary $60 member 1 choose streetdance > automaticaly 50 member 2 choose streetdance + breaking > automaticaly 90 member 3 choose streetdance + contemporary > automaticaly 100 is that possible? Thank you!! :slightly_smiling_face:

I am evaluating productivity of another team in AirTable. The team in question enters their projects and tasks into AirTable, however many Task start dates were not entered by users. Is it possible to export the date each task was entered to AirTable in a fairly simple way, or is it impossible to collect that data retroactively without already having an API set up? Thanks.

I am trying to make a quote builder in an “opportunity table” The way I do it is I mark a company/contact (in their respective tables) as “in progress” and a record gets created in another table (called Opportunities). in there I link to a products table and delivery table (the products are ad spaces, the delivery are the publications/issues) and then I add lookup fields and counting fields to make one quote. I have made 4 copies of this to be able to put together multiple offers for the client to chose from. After filling out fields, I would like to be able to click a button for the quotes to aggregate to a pdf (or straight into the body of the e-mail) and sends it to the contact. I know there’s a solution similar to this for contracts that requires two other apps (zapier and helloSign) but I’m wondering if there’s a way of doing this without the extra apps.

Hey! I am struggling to search records in integromat. I have a table with field Status and Last Modified Status autofield. When I try to fetch data with integromat with formula everything is ok: ({Last Modified Status}) but when I add condition to the formula: ({Last Modified Status} <= "{{addDays(now; -30)}}") it fails with: The formula for filtering records is invalid: Unknown field names: last modified status I also tried this formula with the same error: IS_AFTER({Last Modified Status}, "{{addDays(now; -30)}}") Any ideas how to fix this error?

Hello! I’m looking to create a calculated field that shows me the number of days it takes to complete a record. The start date should be when the record is created, and the end date will be based on a dropdown field’s value (e.g. when the status field is set to “complete”). My thinking is that I need to create three formula fields: The date when a record is created (I’ve managed to achieve this part). The date when the status dropdown field is set to “complete”. The difference between the two dates in days (I’ve managed to achieve this part). So basically I’m missing how to create the 2nd field. Am I approaching this the wrong way? Is there a better way to show this report that doesn’t involve using an app add-on? Thank you!

Hello! I am brand new to Airtable scripting and trying to get a very simple script to work with no luck. What I am trying to accomplish is to have a use click a button then run a script to update 2 fields on that record. I have pieced this together and it doesn’t show any specific error but also doesn’t change the field (I am starting with only one first to see if I can get this working). Any ideas on what is going wrong? // Change these to match your base. let table = base.getTable('Master_Table'); let field = table.getField('Step'); // When run from a button field, the script skips the prompt // and automatically uses the button's record. let record = await input.recordAsync('Choose a record', table); let value = field.updateOptionsAsync.toString("QC Ready");