Jun 27, 2023 01:10 AM
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!
Solved! Go to Solution.
Jun 27, 2023 05:55 AM - edited Jun 27, 2023 05:56 AM
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
Jun 27, 2023 02:59 AM
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?
Jun 27, 2023 04:56 AM
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.
Jun 27, 2023 05:55 AM - edited Jun 27, 2023 05:56 AM
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
Jun 27, 2023 08:01 AM
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!
Jul 31, 2023 07:59 AM
Hi @Owen_Smith , could you please explain how you managed to add a calculated field in a form?
Jul 31, 2023 08:22 AM
I used an interface to achieve this, rather than a form @Rafael_Oliveira
Jul 31, 2023 08:53 AM
@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.