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!
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!
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?
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?
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.
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.
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
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
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!
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!
Hi @Owen_Smith , could you please explain how you managed to add a calculated field in a form?
Hi @Owen_Smith , could you please explain how you managed to add a calculated field in a form?
I used an interface to achieve this, rather than a form @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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.