Other Questions

Hello, I need help with creating an if then that statement. I want to create a formula where if a record is created then the status should change to “needs to be scheduled”, if the scheduled checkbox is selected then the status needs to change to “needs to be submitted to publication”, if both check boxes are filled then it will change the status to “complete”

I’ve added a new collaborator and she can see our base and edit records. She cannot however create new records. Where I have a +, she has a lock. I’ve tried changing her permissions via the table’s drop down edit permissions menu. I’ve tried each option for her on the workspace, editor, creator etc. I’ve also tried manually selecting her via the “specific users” option on the table. Any tips on how to enable her to add records?

Hi, I have a list of workouts with exercises in each row and another sheet with list of all exercises with details about them (equipment, pictures, and …). I used relational to link exercises in workout sheet to exercises in a list of all exercises sheet but then when I do rollup or lookup for pictures and instructions of the exercises it just displays them blank. Why is this happening? Side question: when I do relational sometimes it duplicated the data. So if I relate row 1-5 in Sheet A to row 1-5 in Sheet B, all the values in that row in sheet B are duplicated. So rows in sheet be would go 1-5 and then 1-5 would be repeated again below it. 1-2-3-4-5-1-2-3-4-5. Why is this happening and how can I stop this? I’ve been working on this for a few days now and it’s driving me nuts.

Hey Community, I’m trying to create a formula to add 7 days to a {Date} and add the Last Modified time to the the end of the result. I am currently using this formula DATEADD({Date}, 7,‘day’) & DATETIME_FORMAT({Last Modified}, ‘h:mm’) but this is what I get back example: 2021-12-07T00:00:00.000Z6:35 I have also tried adding SET_TIMEZONE({Last Modified}, ‘America/Los_Angeles’ after the DateTime_Format but I am met with the same result. Would love some help please!

Hello, I have made an Airtable base and would like to require people to fill out a form before being able to access it. Is this possible? My thought is that in exchange for providing very valuable data in my airtable, I could collect their name, email, and some other required fields before they can gain access. Please let me know if there are certain integrations I would need to make or if this is at all possible.

Hi All, How our system work: We have a 3 step application process… Applicant complete Typeform A. Data is sent to Malchimp and Airtable. Malchimp sends out a specific email with a link to Typeform 2. Applicant completes Typeform B. Data is sent to Mailchimp and Airtable. a Panel of about 5 people reviews the information on airtable as provided by the applicant. We give admission on Airtable (Yes/No) which triggers a new email to be sent via Malichimp with the 3rd and final Typeform. Question: We want to create an automated vorm on Airtable to rate applicants. The vorm should include some info of the application that is going to be rated. We would like this to be an automated process which sends out the vorm to 5 emails(our panel). The vorm that they would receive would be applicant 1 or 115 for examp

Hi, I am using Airtable as a personal CRM and have a table with each person listed individually e.g. father, mother, child 1, child 2 etc. and then details e.g. dob, address (in multiple fields), email etc. I also have a field linking spouse, children, parent etc. However, I am trying to find a way to link the address so that I can update one record when the family moves house (rather than all 4 individually). Any help please?!

I’ve created an employee survey. I’d like to send it out periodically and track the results. What are my options for doing that (capturing the results)? Where do the results get captured? Can I track the results of the entire survey AND individual questions? Any helpful Airtable support links you can point me to?

Is there a way to select the second line in your google docs as a source of information to input within a record. For example, I want the second line that I write in google docs to fill out the “subtitle” field.

I would like to import a csv with more fields than are in my Airtable, and I want Airtable to expand its table to include all the data in the csv, including the first row as field headers. Is this possible? The only work-around I was able to do was paste the first row into row 1, which expanded the table but I’m working with 50+ fields so manually renaming them one by one is not ideal.

I would like to create multiple new row entries from a long text. My current long text looks something like this, item1,2 item2,3 item3,4 Is it possible for airtable to seperate the entries into multi rows and columns? Item | Quantity item1 | 2 item2 | 3 item3 | 4

Hello everyone. I’m trying to set up an automation to create new records in airtable when I update a row in a google sheet. A little background, I’m using an email parser to gather order data from emails, which are then sent to the google sheet. I want the google sheet to then update my airtable orders page. Mostly it seems to work, except that I can’t seem to update linked fields. For example on my orders page, each order is linked to a “Customer”, and I have a separate “Customers” page. If my google sheet has a name for the order, it is unable to update the “Customer” field on the orders page. However, if I create a new column which instead of being linked to my “Customers” page, is just a single line text field, then it is able to update. However then I’d have to manually go in and edit the linked “customer” field. Is there anyway to have the google sheets to airtable automation update a linked field? (Link to an existing customer?) Could it also crea

I currently need to calculate, given any date, what is that week’s Saturday. I am currently using to following formula: IF(Start,DATETIME_PARSE( DATETIME_FORMAT(DATEADD(Start,-DATETIME_FORMAT(Start,'e')+6,'days'),'Y-M-D'))) , where Start is the date to be used as input. The issue I have is that, while it works in the middle of the month, If I have a week that spans multiple months, this does not work. For example. inputting 1 December 2021 should yield 4 December 2021 as output, but I get 1 December 2021 back instead. If I input 8 December 2021, I get the expected 11 December 2021 as output. Any ideas on how this can be fixed?

I have a List where I want different non-registred people to enter data using a form, and afterwards being able to see the results. It works well with the form, and I have the link to the shared grid view after the submission, so that the people can watch the results. The grid view is grouped and I have the problem, that the view is not grouped on mobile phones. It works fine on PCs. However, the view is grouped on any device as soon as I have signed in. So it is only the shared-by-a-link-view that is not grouped. Anyone knowing more about this issue? Thanks in advance, it would make my life so much easier! :slightly_smiling_face: Best Peter

Hi I am stuck with a problem here. I have two tables. Table A where a single record can have multiple relations to records in Table B. In Table B I have a field with numerical numbers. So my challenge is to make a form from Table A that can manage a one to many relation in Table B AND add the numerical numbers to Table B as single records. The numerical numbers show up in Table A as numbers seperated with commas. Is there a way to accomplish this. I have made Interface that works in the new Interface Designer. But the interface seems not to do well on mobile units and can not act as a form without a user to be logged in. Is it possible to have it as a form like in views ?

I’m trying to be able to sort my groups by the first created date/time of a record in that group. Essentially, I am trying to create an order form, where the customer’s phone number is the primary field. Each item a customer orders will need to be its own record, and there might be multiple customer orders coming in from the form by different employees sometimes a few minutes apart, but each customers’ items would be fulfilled at the same time. In my screenshot, I would need the 0433 order to come 2nd, as the the first item for them was placed before the first item for 0422 . Any help would be greatly appreciated!

I want to sync one view into another base. I found this documentation stating how to do that. As far as I understood, that Link that I create can be viewed by anybody in possession of that link. In addition, I can protect it with a password, but then the sync will stop working. Is that correct? If so, the sync feature is pretty much useless for everyone who doesn’t want views to be accessible publicly (I know, it’s a private link, but I don’t really trust that kind of private link), or am I mistaken? Am I missing something here?

Hi, I would like to design a base that multiple managers can see which employees (labor hands) are available in half day increments (morning and afternoon). Ideally, managers have a running task list that is then assigned to an employee and all managers can see which time slots are taken and available. Currently a spreadsheet is used with 2 row entries per labor hand (morning and afternoon) and a column for each calendar day of the year. A tab is within the spreadsheet for the running task list and each task is given a number. That number is then assigned by typing in the appropriate cell to an employee for a specific date or dates for the morning and or afternoon. I’ve considered making an airtable with all calendar dates with 2 records each (morning and afternoon) then having a form created to send to each employee with their availability. The form isn’t allowing multiple dates to be selected. The problem is the ease of use with the spreadsheet for managers is high, meaning

Hoping you all can help a new Airtable workspace user out. I’m trying to find the right combination of permissions that would allow someone outside our organization to: Access a table or base ideally with a shareable link and Have editing access to the fields in selected column only. Essentially lock/unlock columns while all others remain read only. I do not want to give access to: Expanding records which allows information in the hidden fields to be seen. This happens when giving read only and above access to a base users. Is this possible? Any insight and guidance is greatly appreciated!

I have a base and a table that tracks a list of classes by title, also showing date and assigned faculty. I need a list organized by faculty showing which classes they have each taught in the past. The assigned faculty is a linked record field that pulls faculty names from another table. This at least gives me a list organized by faculty. But, when showing the courses they teach, it shows every instance of a course taught, which may result in too many duplicates. For example, if John Smith teaches Class A 20 times in a year, Class B 5 times in a year and Class C 3 times in a year, I just need a list showing John Smith teaching 3 classes, not 28. How can I eliminate those 25 duplicates and just get a list of each unique course title taught be a faculty? So far, I have just exported to Excel and manually removed duplicates. But, this is a time consuming way to run a report regularly. Any help is very much appreciated!

I have an onboarding form at google forms. I know you can use type form to sync to Airtable but I already built the google form and its free how to keep a google form sync’d to Airtable is it still just Zapier?

hey I have a service co there is client info and notes on the job one field is materials needed so I made a view of just the field of materials needed but now I would like to operate on that you know, sort it by supply house or group it independant of the job or dependent on the job. any way to gather up all the entries for this field over many records and then sort them, and then put them back to view in other ways? it would even be best if we could call from a database of commonly used materials when we made notes on the job thanks!

Hi, I’m struggling with this script (I’m a newbie) you see below. I have the array “dependencyOrderSplit” which, can have more than 1 string object. I should use these strings to filter thru “let filteredRecords = queryResult.records.filter” and comparing the string field “order” with ALL the objects [0, 1, 2, etc.] and retrieve the record.id which comply with that. My problem is I don’t know how to obtain a new array with ALL the filtered records. If I use [0] as in the example, only object 0 is retrieved, but object 1 not. Any ideas?

Having issues coming up with the following formula need. I have a “Delivery Date” field with a date. I have another field where the forumla will be “Settlement Date” The Settlement Date needs to look at the Delivery Date and then automatically calculate next weeks Friday date. Issue is the work week is Monday-Sunday and pay day, or “Settlement Date”, is the next week on a Friday. Example 1. Delivery Date = Sunday 12/12/21 then Settlement Date = 12/17/21 Example 2. Delivery Date = Monday 12/13/21 then Settlement Date = 12/24/21

Not 100% sure on the best way to create a CRM & Project management setup. Currently we have the pipeline in one tab, a list of jobs in another tab, all the shifts including £rates in another tab. We want to keep the pipeline tab for selected people only. We also want to hide the £rates fields in the shifts tab so to prevent certain people from viewing them. How can we restrict views of tabs and certain fields please? Is it even possible to hide tabs? Or is it better to create a separate base and have certain fields auto sync to the other base? Thanks in advance. Pete