Skip to main content

How to add a new record from an interface?


Show first post

52 replies

Justin_Barrett
Forum|alt.badge.img+20
Sean_Lake1 wrote:

This only works if you don’t already have a filter setup in your upper filtering. I’ve found in the interfaces that if I try to add multiple filter selections, that they reset/disconnect when I press publish. So I can only have filter set on my records directly on the left(in the interface) and one on top, a filter I drag into my interface.


I had to remove all but one filter at the top for it to work correctly.
So having a button, or a fix to this filtering issue, would be quite handy.

Sean


Resetting filter options when publishing isn’t uncommon. It’s annoying to set them again, but after publishing they remain unchanged between sessions from my experience. However, are you saying that after publishing, the filters no longer work at all? If so, that sounds like a bug that should be reported to support.


Sean_Lake1
Forum|alt.badge.img+16
  • Inspiring
  • 100 replies
  • February 2, 2022

Hi Justin.

Yes, the filters not only disconnect from their source, but don’t work at all, no matter the options I/we choose, which obviously defeats the purpose.
It works fine as I said as long as I add a filter to the listing side’s direct filtering options, but if I add more than one additional filter on that top section, as you see(or anywhere in the view), it causes all the filters to not only disconnect from their source, but not filter anything.

So yeah, I think it’s a bug or not the intentions of the programmer/developers??


Forum|alt.badge.img+8

I wanted to add my name to the list here - an EASY way for people to add records in the interface (when allowed) would be great.

I like the idea of using interfaces for my clients, so they don’t need to go into the backend of the base. However at this moment I give them access to their interface AND extra forms so they can add content to said interfaces… it’s a bit of a hassle.


Justin_Barrett
Forum|alt.badge.img+20
Sean_Lake1 wrote:

Hi Justin.

Yes, the filters not only disconnect from their source, but don’t work at all, no matter the options I/we choose, which obviously defeats the purpose.
It works fine as I said as long as I add a filter to the listing side’s direct filtering options, but if I add more than one additional filter on that top section, as you see(or anywhere in the view), it causes all the filters to not only disconnect from their source, but not filter anything.

So yeah, I think it’s a bug or not the intentions of the programmer/developers??


@Sean_Lake1 In that case, definitely report this to support@airtable.com so that they can get it on their list of fixes.


Sean_Lake1
Forum|alt.badge.img+16
  • Inspiring
  • 100 replies
  • February 3, 2022

I’m working with the Enterprise team support, and made them aware of this. Thanks for all your assistance!

Have a great weekend.

Sean


Forum|alt.badge.img+16
  • Known Participant
  • 61 replies
  • February 21, 2022
Justin_Barrett wrote:

The first option that @kuovonne listed is what I’m doing. I also have a “New” checkbox field, which is checked only on that blank record, and a filter in the interface to control the record list based on that field. When unchecked I can browse through all records except that “new” one. When checked, only that blank record appears in the list, making it easy to add something new.


Having basic, native function in the interface like, ADD Record and DELETE Record would be very important to really work in that interface.


Justin_Barrett
Forum|alt.badge.img+20
Tobias_LGKR wrote:

Having basic, native function in the interface like, ADD Record and DELETE Record would be very important to really work in that interface.


Welcome to the community, @Tobias_LGKR! :grinning_face_with_big_eyes: I completely agree, and I’m sure that the developers have that on their radar. The workarounds that @kuovonne and I have been promoting are just that: workarounds to help people get the job done while we wait for Airtable to add features to the interface system.


  • New Participant
  • 2 replies
  • February 24, 2022

Just jumping in here with you all :slightly_smiling_face: I came here to find if there was a way to do this as well, but - for beginners. I watched the video above, but since I’m not yet familiar with all of the terminology, it was harder for someone on my level to follow. When in gallery view, the convenient plus symbol that’s down in the bottom right, is something I use regularly when adding records, and when I created the interface, I was saddened to see a useful function like that as not available. I’m sure with all of the people that are talking about it though, perhaps we might see it in the future as a few of you have mentioned. Regardless of my ability to keep up, the information in this thread was very helpful, and thanks everyone! :slightly_smiling_face:


  • New Participant
  • 2 replies
  • March 7, 2022

Adding my vote here. Adding / deleting records would be fantastic.


Forum|alt.badge.img+16
  • Known Participant
  • 61 replies
  • March 9, 2022

As I have been digging into the Interface Designer and using it extensively:

It’s totally awesome but without ADD, DUPLICATE and DELETE Records functionality natively built in, it’s a dead end as far as data management is concerned.

Dear Team, PLEASE put that at the top of your Interface List.


+1 I’d love to see this too.


I was expecting to want to pay for Airtable, assuming that I could create records nicely. Definitely a surprise, that it’s not an option.


  • New Participant
  • 2 replies
  • April 13, 2022

+1 watching this thread


Thierry_Gattlen
Forum|alt.badge.img+8

It is very confusing for user that they cannot add a new record. I hope they will add that functionality soon.
I use the link to forms to add new records, but this is not satisfying.


Forum|alt.badge.img+3
  • Participating Frequently
  • 5 replies
  • May 3, 2022

Hi Justin. Could you please share the formula you used for NEW record please? Was it an IF formula?


Justin_Barrett
Forum|alt.badge.img+20
Molly_1 wrote:

Hi Justin. Could you please share the formula you used for NEW record please? Was it an IF formula?


Unfortunately I can’t because such a thing doesn’t exist. Formulas cannot create records, nor can they change the output of other fields. Formulas can only retrieve data from other fields.

In one of my comments above (linked here for convenience) I share one way to do this using an automation.


Forum|alt.badge.img+1
  • New Participant
  • 1 reply
  • May 9, 2022

I create a table (grid) and use the “+” button to create e new record; a bit too “invasive” for a simple button, but the only easy way till now


Hello everyone !
I might have a solution to create a new record in Interface !
You make sure you already have created a Form.
Then you go to Interface and add a “text element”. Put it anywhere you want (I put it on the top of the page). Name it as you wish (I put "Add New Record HERE) and then put the link to your form into “HERE” (for exemple).
In France, we say: “when a door closed to your face, enter by the window !!!” :rofl:
Hope this helps !


Forum|alt.badge.img+2

This feature is needed +1


Forum|alt.badge.img+1

+1 this is a desperately needed feature.

People have been begging for this badly needed feature for months. Please.


Forum|alt.badge.img+6

Although I have tried some of the suggestions mentioned above, they still don’t feel natural enough for me to deploy an interface to the rest of my team. I agree with the previous commenters that we need a better solution.


kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6002 replies
  • July 12, 2022

Per this post we can expect the ability to create a new record in interfaces this month.

Of course, it isn’t clear what that method will look like and what features it will support. (For example, it isn’t clear if it will support the creation of new linked records or records with defaults.)


Sam_Fish
Forum|alt.badge.img+7
  • Known Participant
  • 11 replies
  • October 26, 2022
kuovonne wrote:

Per this post we can expect the ability to create a new record in interfaces this month.

Of course, it isn’t clear what that method will look like and what features it will support. (For example, it isn’t clear if it will support the creation of new linked records or records with defaults.)


Any update on this?

seems like i still can’t create a new record in a linked table.


kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6002 replies
  • October 26, 2022
Sam_Fish wrote:

Any update on this?

seems like i still can’t create a new record in a linked table.


Airtable added the ability to create a new record in the current table. However, adding a new linked record is different. Currently, to create a new record in a linked table, you need to have the linked record field displayed as a field, not as a grid. And it takes several clicks.


Forum|alt.badge.img+6
  • Known Participant
  • 19 replies
  • February 23, 2023

Same!

 


Reply