Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

New Block idea - Form for adding new record

cancel
Showing results for 
Search instead for 
Did you mean: 
Nick_Burrus
6 - Interface Innovator
6 - Interface Innovator

I would like to have the Add record form in a block, so people can easily add data while viewing the spreadsheet.

14 Comments
Chad_Hokama
4 - Data Explorer
4 - Data Explorer

+1 on a “Form” Block or more generalized “Input(s)” block that would optionally generate a record. I need this to create various calculators. Our sales team needs to enter variables into a form which generates a value. Currently there is no view in airtable that supports having a form in the same context as its generated record.

Spencer_Maybee
5 - Automation Enthusiast
5 - Automation Enthusiast

+1 however I think having the Forms view actually operate as a view instead of a data entry tool would be great. That way a) you could enter data while viewing the context of that data within the record, but also b) you could use the Form view to organize the information in your base and view it contextually (e.g. all info about your client in a simple data card instead of as a row in a spreadsheet).

Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

Doesn’t the “Gallery” view do this? Or is that not what you are talking about?
image

Spencer_Maybee
5 - Automation Enthusiast
5 - Automation Enthusiast

Gallery is closest, but to be able to customize the layout (throwing back to early FileMaker Pro/MS Access days) to be able to view in customized order would be the dream here. Thanks for pointing that out!

Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

Like this?
image.jpg

Spencer_Maybee
5 - Automation Enthusiast
5 - Automation Enthusiast

It’s close, but optimally has this amount of information (see attached) visible in one screen (i.e. with no scrolling) and can be customized, moving and resizing fields to optimize that visual space.

script-breakdown-sheet.jpg

Spencer_Maybee
5 - Automation Enthusiast
5 - Automation Enthusiast

Instead of:
FIELD NAME

Field info.

FIELD NAME

Field info.

Etc.

Something like:

FIELD NAME: Field info. FIELD NAME: Field info.

FIELD NAME: Field info. FIELD NAME: Field info.

Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

I see - I gotcha now.

So you want a combination of the “Page Designer” block with a form for data entry.
That sounds like it could be useful!

Spencer_Maybee
5 - Automation Enthusiast
5 - Automation Enthusiast

Jeremy, you kind of nailed it, though tbh, it looks like the Page Designer block is more what I’m looking for (though data entry in that view would be handy). I didn’t know much about blocks and certainly hadn’t discovered Page Designer. I’m not an upgraded user, but I’d definitely consider upgrading to access this feature if it works the way I think it does.

Thanks for all your responses!!

Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

Sure!

The Page Designer block allows you to design a layout by placing and formatting your “Fields” onto a page -

example:
You have a “Project Name” field, a “Start Date” field, an “End Date” field, and a “Photo” attachment field.

You can drag “Project Name” as a field onto the page, place it at the top, change the font/size/weight to make it a page header kind of deal.

Then drag “Start Date” onto the page underneath the header, format font/size/weight.

Then drag an adhoc “Formatted Text” object onto the page, type a " - " into it, and place it after the “Start Date” field.

Then drag “End Date” onto the page to the right of the “Start Date” " - " you have on the page, and format.

Then drag the “Photo” attachment field onto the page where you want - size it, give it a border, etc.

And end up with something like this (mind, I haven’t gone to the effort to replace those deleted fields…):
image

And once the layout is made you can apply the layout to each record in the table that the block references (ex. “Projects”). You can click through each record using the arrows at the top, or search for a specific record to pull it up.

You can search for a record to view:
image

And it shows up like this in your blocks section:
image