Update a calculated field within an Interface or Form

[Owen_Smith]

I want to populate a calculated field using data input into other fields.

Example: 

Q1 = XYZ
Q2 = ABC

Calculated Field = Q1&Q2 = XYZABC

Is this possible to achieve in either an interface or a form?

Thanks!

[TheTimeSavingCo]

Hm, could you talk more about your expected workflow?  A formula field with `{Q1}{Q2}` would get you the result you want, but it seems you want to activate this or something?

[Owen_Smith]

Here's an example but in Jotform:
https://form.jotform.com/231773130806048

I'd like to be able to do this in an Airtable form or interface is possible.

[TheTimeSavingCo · Accepted solution]

Ah, yeah I think that's not possible I'm afraid.  You could get functionality that's close to that in an interface with a record that already exists, but not for creating new records I'm afraid:

You could look into third party options like FillOut, On2Air etc for this though, I believe they have this functionality

[Owen_Smith]

This is exactly what I need - it was the Record Summary layout I needed. 

I looked at this before but didn't notice the Permissions setting in the right sidebar - I changed that to editable, and  can now calculate a field based on drop-downs, thanks for the help!

[Rafael_Oliveira]

Hi @Owen_Smith , could you please explain how you managed to add a calculated field in a form?

[Owen_Smith]

I used an interface to achieve this, rather than a form @Rafael_Oliveira 

[Rafael_Oliveira]

@Owen_Smith 
Could you please show me where? I am stuck trying to find a way to put a calculated field in a form, even in interface form, but I cannot find a way.