Other Questions

For the base I’m using I’d like when people register for the table to auto-populate their IP address. I’ve gone through the formula list and have seen nothing related to this. Is this even possible with airtable or does it require some third party interaction?

Newer user, still learning. I have a base with 3 tables. All three tables are linked. When I send the form to collaborators, they cannot add data to the two other tables (through the form). This base is similar to a CRM, so I am trying to add customers, potential jobs (on a separate table) and contractors (on another table). The Customer Base is the form being sent out, but if the contractor or job isn’t already listed, then it cannot be added through the form. Is there a method to add a contractor or job through the Customer form?

Hello, I’m certain it isn’t possible but it is worth an ask. I am hoping to use Airtable for a moving business which takes an estimation form from the website over to a table. From there I have an Origin Address and a Destination Address which I can easily link to 2 x map views. What would really be an amazing feature for us is to print this job off via the Page Designer Block but with the two maps embedded in the page designer. Basically so we can print a comprehensive job sheet with all details plus the 2 x map views. I have tried to find a way but am at the point thinking it isn’t possible, is this the case or can someone suggest a way to implement this? Thanks in advance for any replies.

I would like to ask if a form is able to store the User-Agent or the IP/Geolocation in a table?

Hi everyone, Is there anyway to make one-to-many relationship kind of master-slave relationship? What I mean by master-slave here is making one table master and the other slave so if someone deletes a record in the master table, related records in the slave table would be automatically deleted. Is this kind of things are possible? Thanks!

Hi, is there any way for us to search for keywords in hidden fields? We have a ‘Tags’ column but it is not aesthetically pleasing in Gallery view. Is there a method or workaround? Many thanks

I’m trying to make a referral form which the user can enter a name and phone number to send a gift to. where I get stuck is restrict answers to be only new phone numbers (if the user try insert number that already submitted he’ll get a message that indicate that)

Hi there, I accidentally upgraded my plan from free to pro on 23-Jun-2020 and only found out on 13-Jul-2020. If i downgrade my plan back to free on 14-Jul, can i get a prorated refund for the period of 14-Jul-2020 to 23-Jun-2021? Thank you for your help! Carol

I am attempting to create a payroll form for contractors to submit their hours on a daily basis. How do they take the shared form link I email them and have it installed on their IOS device as an app-let for daily submissions? I know how to create the link, its the other end of the install I am having issues with. Many thanks for your help.

Has anyone gotten multi-select field to work in Formnano. My airtable field is multi-select, when I set the formnano field to multi-select I get an error #422. I also have no way to populate the field options in formnano.

Hello, Is FormNano still a good app to use for updating or adding new records to Airtable? I can’t seem to get a hold of their customer support.

My PDB report includes a Multiple Select field and the report requires a LIST format instead of the defaulted line of selected items… Q> Is there a way to have the print changed to a LIST format?

How the heck do I report bugs now? I have a linked record field that is supposed to be limited to a specific view. It works most of the time, but often enough, the entire linked table is exposed. When this linked record is functioning properly, I can hit enter, then enter again and select the desired record, as it is the first in the list. When it isn’t working properly and I do the same enter + enter combo, I select a name that shouldn’t be there. When the box closes out, no record is displayed in the linked record field. That is great, but something VERY ODD happens. The situation is this: Each project has several project contacts Each project contact is associated with one other contact (usually myself) While working on a project, if I need to add a new project contact, I simply click add new record From there, I select my name from the limited view linked record. When this doesn’t function properly, I mistakenly select the name of the first contact in my contacts table. This contac

I am using a Unity plugin for Airtable. It is asking for the API version. I can’t seem to find that in my account. Could someone tell me where it is located?

Is there a way to copy, export, or embed a block so I can show just the block (and not any of the underlying data) in a google doc? Right now I am just taking screen shots but the quality isn’t very good and the image becomes out of date very quickly.

Is anyone using Memberstack and pulling data from Airtable to make a private client dashboard. I’m using Duda as CMS and have integrated Memberstack. Now I need to pull user data, stored in Airtable, and share with each client. Stuff like “Order numbers”, “tracking #”, etc.

How can I hide certain records from being displayed? We are using an Airtable form to collect entries but only want to display people we approve to the public gallery view that is embedded on our site. Is there an affordance to hide some records? For now, we just had to create a duplicate form to act as an overall collection sheet, from where I am then copying approved entries to the live gallery directory. Can this be made more efficient/easier?

Hi, I’m not very clued up when it comes to the more complex features of Airtable so I’m hoping someone in this community can offer some assistance :slightly_smiling_face: I managed to solve part of my issue through searching these community forums here I am using UK postcodes to determine a salesperson’s region. I have a list of these vs salesperson which can be viewed here. I have a webform that is pulling into Airtable using Zapier so it populates the fields whenever a form is submitted. I’m now adding some extra fields to this so that our sales team can utilise the base as a leads tracker. I’ve got as far as using a formula to assign a salesperson based on the first 2 digits of the postcode: And that is working ok, but it leaves me with the issue of when a postcode starts with a single letter as is the case on line 5 here. I also wondered whether it’s possible to add a collaborator based on the postcode so that they would be notified, but I think that might be a step too far vs w

Hi. I am currently trying to use Airtable for collaborators to be able to review applications and then use the form to leave input. I have all the information in a couple of tables and galleries, but I think I have hit an issue. I would like each collaborator/reviewer to only see information pertaining to the applicants they were assigned and not all applicants but do not know how to do that. Do I need to create more views or am I missing something? I would appreciate any help on this. Thanks.

Hi Airtable I have an Integromat scenario to backup Airtable records, but it does not seem to work. I keep getting a RunTimeError. I am also not getting the Multi select options for each record, filled in each field. Can someone take a look? Maybe @ScottWorld? Here are screenshots of the scenario and error.

It would be great if there was a way to automatically update the field on Airtable when you change the label in a gmail inbox. Can this be developed?

Hey community! Absolutely love Airtable and its simplistic multi-functionality. I love it so much, in fact, that I would like to make it an integral part of a new function on our website. This request goes a bit in the direction of allowing “Embedded Form CSS Styling” but is a little simpler. I would just like to be able to give out a very simple airtable view as TEXT ONLY, without the background, colour, option to expand, download csv etc. I don’t mind having the Airtable logo there. Is there a way to do this, or–frankly–another plugin for WP or any other way to achieve a similar result? Thanks very much in advance!

Hi, I am making a table of companies which then list the investors in that company as a multiple select field - like ABC Company as the record name, and then “DEF Fund,” “GHI Investor” as the selected investors. I want to then import a new list of companies and investors, which would only add new ones to this list - not overwrite the existing fields - in this case, lists of investors are often incomplete so ideally I could import multiple lists of investors and companies and capture all the investor names. So for example, if I imported a list of investors and companies to the base above, which showed that that “DEF Fund” and “JKL Fund” were investors in ABC Company, I’d like the result to be all three - “DEF Fund,” “GHI Fund,” “JKL Fund”. It just adds the new ones, doesn’t remove GHI Fund because it wasn’t in the new list - only additive. Any thoughts on how to do this? Thanks in advance for any ideas!

DATETIME_FORMAT(SET_TIMEZONE(Date, 'Australia/Brisbane'), 'DD/MM/YYYY') This is not working for me. It doesn’t matter what I set the timezone to, it keeps saying it is yesterday. I need help to fix this because it is driving me crazy.

Hi everyone! I am needing some assistance writing some code to be able to automate some things on my workspace. If you have experience with this, and would be willing to help us out, please let me know! We are wanting to optimize Airtable in a way that allows us to use it a reference, and not as much as something we have to continue working on constantly. Thank you in advance!