Other Questions

Hi everyone, Was just wondering if anyone had any recommendations on which would be better between the Maps app and Vega-Lite if my goal is to take a table with 11 geographic regions, shade them on a world map based on a roll-up value in the table, and then add marks for listed locations within those regions (already have the latitude/longitude for them). I thought some sort of layering in Vega would work, but I’m honestly having more trouble with the shading part than the individual marks. Would be thankful for any input!

Hi all, I have 2 tables in a base (Businesses & Users); I’m using the scripting block to upload a JSON file and add new records to the bases if they don’t already exist. Attached are the screenshots of the 2 tables and the script. When the ‘Users’ & ‘Businesses’ fields in the 2 tables are not linked, I can update the records with the script, but when they are linked, I get the following error when I run the script. What can I do to fix it, please? O: Can't create records: invalid cell value for field 'Users'. Cell value has invalid format: <root> must be an array. Linked records field value must be an array of objects with property 'id' corresponding to linked record id. at spawnErrorWithOriginOmittedFromStackTrace on line 1 at _assertMutationIsValid on line 1 at applyMutationAsync$ on line 1 at tryCatch on line 1 at invoke on line 1 at tryCatch on line 1 at invoke on line 1 on line 1 at Promise at callInvokeWithMethodAndArg on line

I have a base to keep track of the FESTIVAL PARTICIPATION of each of our FILMS. In table 1, I record the participation of each FILM on different festivals (which I pull from a FESTIVAL DB in table 2). This means that on table 1, on the first field {FILMS} film1, film2, film3 are recurrent values, appearing in as many records, as festivals where they get invited. In table 1, I include a text field named {SOCIAL MEDIA} where I include the film’s social media related profiles and hashtags. I do that on the first occurrence of each film on a record. MY PROBLEM: I can’t figure out a way to either LOOKUP, ROLLUP, or find a FORMULA to reproduce the info I entered in {SOCIAL MEDIA} for a particular FILM X in a record to another record in the same table where FILM X appears. In my mind is like making an intra-table “related field” but I cannot figure out how to do it.! I made the image below to better explain what I need, in case I did not expressed myself clearly. airtable-1|700x268

We used to hit the 20GB Attachment space, base limit about every 4 months. Our work around was to create archive attachment bases by duplicating the base. Then we would delete the older attachments in our working base. Now, we want to bring some of those attachments back. I am struggling to find the right solution to link or line up the records properly to bring the attachments back. I thought I could create a new table with an ID to link the tables and the attachment fields. The obvious choice for the ID was to use the RECORD_ID(), but I learned the duplicated bases created new RECORD_ID()s. I tried a few formulas to create the ID using create date and other fields, but they were not discrete when multiple records were imported at the same time or duplicated. Anyways, I have looked around and I tried few things. I am I am looking for ideas. Thank you in advance.

I have a base with a table full of tags that is used to tag different items along different dimensions. Each item can be tagged in alot of differnt categories. I’m trying to use airtable in conjunction with Bubble.io and it seems I’ll make life easier for myself if I rename the linked fields back in my tag table to something more meaningful rather than tablename 1, tablename 2, tablename 3… Is there a quick way to see what these field corresponds to, so I don’t have to toggle between tables and try to match up which tags are present where?

Hi, everyone. I’m wondering if there’s a way for me to adjust the date and time in the following format: [MM/DD/YYYY XX:XXpm] for Slack and Email. I can’t seem to do that in the automation box. Would I need to insert a formula or some other solution? Thanks.

I am trying uploading an image from webflow form to airtable using zapier. All the form data like name, email, etc are getting added to the table when I submit the form except for the attached image. The image column (Attachment) is always empty. So I tried manually add the image using the Link (URL) option and kept getting following error: “Error fetching URL metadata.” Following is the image URL generated by webflow: https://webflow.com/api/sites/3d-jobs-project/formUploads/8070822d-b223-4bfe-9d61-eab61d069dc4.png Any idea how to fix this?

Hi all, first time posting to the forum and hope to become a fellow positive contributing member to the group. I’m looking to design a few different community apps using no code tools with Airtbable as the database. One of the common use cases will be some sort of ongoing activity tracking (ex. # of miles ran, # of calories eaten, # of pushups, etc) or budget tracking ($ spent on rent, $ spent on food, etc) and questions that would require simple text answers (how do you feel today?) I really like the flow of Typeform or even Jotform (free tier) and was thinking I could somehow use either of those tools to collect the user data which gets sent to Airtable but not sure if it’s possible to save it so that the same user can login to some front end tool (ex. Softr or Pory), go to my Typeform link, and it gets saved to their user record in Airtable (did that make sense?) Lastly, if this isn’t possible with Typeform, can I even do this with Airtable fairly easily or will it be a long missi

Hello, for every number I have a reference, a actual and a difference row and I would like to Group them under one Name, like you can do in excel with connecting cells. In this 1 minute video I am showing how it looks in excel: Loom | Free Screen & Video Recording Software If you have an idea how to do it please let me know. :slightly_smiling_face: Best regards, Ben

Hi, I have a field of Skype ID and I’m trying to have a button/field that pressing it will open a Skype chat with this specific user. I found online html code that does that: <a href="skype:<username>?chat">Start Chat</a> I tried using button with open URL ("skype:"&{Skype}&"?chat") but Airtable treats it as http and adds http which breaks the link. I tried opening a script with the script: let table = base.getTable("TEST"); let record = await input.recordAsync('Pick a record', table); let link = "skype:" + record.Skype + "?chat"; output.markdown(`[Click here](${link})`); but the link built doesn’t open anything. I tried URL field but again the http is added. I tried using long reach text field with markdown code: click here and it doesn’t work too… Please advise how to do it. Thanks, Amit

If I am free plan, can I add a record with the form mode? I tried but it popped up this window. I am not sure whether it is due to free plan.

Hello, I run a fitness gym and would like to set up a workout reminder in Airtable. This means that our members fill in a form with their e-mail, choose their training day (e.g. Thursday) and then you should receive a short reminder e-mail every Thursday. How can I implement this in Airtabel.

Maybe this is a stupid question, but I have added tasks to a project planning base, and all the tasks I added are marked as completed. Not sure why? How do I uncomplete them?

Not related to Airtable, but I wonder if anybody came across a service where I can push clickable URL address to. I created a dynamic URL formula to Airtable form with help of kuovonne’s Prefilled Forms. That URL changes and new URL is generated after the previous form was submitted. So now I am looking to upload upload that URL somewhere online where I can click it in a web browser. I am thinking Zapier or Integromat would watch changes in the field containing kuovonne’s changing URL and it would pick up the new URL and push it somewhere. Where … that I don’t know. I could setup twitter account for example and click the URL in the twitter feed. RSS could also work but I don’t want to display old URLs in the feed. I just want to show the latest version of the URL. However, I am looking for something simple, without need to open an app, something that would work without login, for example web-page and Zapier / Integromat would update that link there. Anybody knows anything like that? M

I was contracting for a company added a person as a collaborator (not owner) in my paid workspace. When I left, that person removed ALL my bases (my personal ones and ones related to other work). I know it was my fault - I didn’t realize people other than owners could remove the entire contents of someone’s workspace. Will not repeat that mistake. Airtable says it has to be returned from that person, but that person won’t return calls/ emails. I followed up with Airtable explaining the situation, last week but have not heard back. Anyone know of A way to get them back A way to call Airtable

Okay - So I have two tables. Table 1 is related to incoming students. In this Table, they select the timing of their incoming testing and tell me key information about themselves (e.g., what program they’re entering). Table 2 is a table of all current students. In this Table, I have key information abou the students and also the results of their testing/ultimate course recommendations. I also track their “Progress toward goals” through a number of complex formula fields. All information that is raw was typed/entered into Table 2 through a long process of converting Excel to AirTable. In Table 1, I have done the scoring and the raw data that would feed into future “Progress toward goals” formulas. How do I get students from Table 1 to populate in Table 2? What kind of linking must I do? There MUST be a better way than copy and paste, as I need to do this multiple times a year, and the columns/fields do not all align (i.e., they are different types of data for different kinds of processe

Hi everyone, I wonder if anybody tried exporting an Airtable base’s structure as SQL create statements for RDB like MySQL or PostgreSQL. I am trying to replicate the Airtable base that I have in a relational database. Product suggestions and tips for the task are highly appreciated. Thanks

Hi, In my table I have a field where I want the expiration date of a contract be automátically calculated based on another date field (when the contract was signed) + 36 months duration period. The formula is as follows: DATEADD({signed}, 36, “months”) Most of our contracts are for 3 year periods, but because, we actually have some that are for one year, I thought I could create another number field where I could set as default the value “36” but eventually could change the number of months to “12”, for example. Now the new formula is: DATEADD({signed}, {contract duration}, “months”) PROBLEM: The date appearing in the signed field is June 20, 2015. In the first formula, the date that resulted was June 20, 2018 (signed date, 36 months later) The second formula however came June 19, 2018, a day earlier. I’ve tried with different month values. it always comes one day earlier. Any tips, suggestions, etc would be appreciated.

Hi. I am using the project tracker template. I have made a number of changes to the fields while in the all projects mode. When I look at the completed projects or incomplete projects view these changes do not show How do I get any changes to show across all views. Thanks

Good morning, I’m trying to create a gantt chart in which I can represent a proyect with different beginnings and ends. But instead of appearing below, continues in another start date on the same line, as it shows in the following picture: The project 26324402 (orange (?)) I modified it in paint to explain my idea. I thank you a lot

I have an attachment field where I upload jpgs. Is there a way for Airtable to get the date created from the jpg I uploaded (not the date the record was added to Airtable) and display it in another field?

My notifications from airtable aren’t coming through as email alerts for some reason. I’m not being notified when: Someone tags me or When a brand submits a form For the forms, it is definitely ticked to email me when a form is submitted, and for tags I have checked my notification settings and it is set to alert me so I’m not sure why it’s not working. I have tried to see if it is working on Outlook or gmail through Chrome and both aren’t coming through. Any ideas on how to resolve? Thanks for your help!

Hello Everyone, I have a table to keep track of projects and the employees that are working on them. We work virtually so I’m looking to create a calendar view to see when projects are ending and an employee would be available to start something new. If a project is 5 days a week until the end date it’s not problem, but I’m having trouble creating a view where one employee with multiple projects could be displayed accurately. For example, one employee is working on two projects and alternates every week (so one full week on one project and the following week on a second project back and forth) or if an employee does 3 days on one project and two days on a second project. I’m wondering if that type of specificity in the calendar view is beyond AirTables capabilities or if there’s some linked data solution I’m missing…

Hey there I have a synced base that is pulling a “percentage” field from another base of mine. I am running a formula field on the lookup field, however it is giving me an #ERROR! as a result. I have tried using Value(), but nothing works…

Hello community, I am working to creating an airtable form that will allow users to provide cost estimates for various conservation activities. Currently, they input this information into a word document and do all the cost calculations themselves. This information is then input into the airtable manually. In the form, I could set up each activity with its own field for cost, unit, etc. to get this information , but would like a cleaner way of gathering this information. So my idea is to create an excel sheet with drop down selections that can auto-calculate the totals for the user. Then have that user upload the excel into an airtable form. But how do I get that information out of the excel and into the airtable table without someone needing to manually do that? I see that it is possible to extract text from a PDF that is attached to a form, is something like this possible for excel? Has anyone ever done something like this? Example of the current table: Any help is appreciated!