Is there a way to populate fields on a form based on previous fields input?
For example, I have a Type field with Type A, Type B, Type C.
After that there are Unit and Cost fields.
If a user selects Type A, then populate Unit with 5 and cost with $1.00.
If a user selects Type B, then populate Unit with 3 and a cost of $10.00.
Etc.
Unit and Cost fields would be Single Select options.
Thanks!
Hello, not an expert but could you use a formula field for Unit & Cost fields? I think this would only be feasible for a small number of options, if there were loads it may be complicated.
I use something similar for my app as follows. This checks the Model (field) to check if the word “Latitude” is there, if it exists the the output is ‘Dell’
IF(ISNUMBER(FIND(“latitude”, LOWER(Model))), “Dell”, “”)
So in your example, maybe this (untested)
Unit Field (Formula)
IF(ISNUMBER(FIND(“TypeA”, LOWER(Model))), “5”, IF(ISNUMBER(FIND(“TypeB”, LOWER(
Model))), “3”, “”))
Cost Field (Formula)
IF(ISNUMBER(FIND(“TypeA”, LOWER(Model))), “$1”, IF(ISNUMBER(FIND(“TypeB”, LOWER(
Model))), “$10”, “”))
etc etc
My use case is too complex for creating formula fields. It’s basically selecting a “type” of deliverable that then populates a dozen plus fields with prefilled data.
Would be great to have conditional forms in Noloco that would allow this.
I think you should be able to do this with Workflows @andrew
When you create the item, use workflows to conditionally populate other fields / related fields.
That makes sense. I was looking for something more flexible based on our needs, but I can create some workflows based on checkboxes to help streamline.
For clarity on what I’m doing, we create Deliverables (videos) for our clients. Those videos have specs (resolution, frame rate, codec, etc). In most cases, we use 2-3 standard set of specs, but there are regular needs to modify those specs.
I was hoping to pre-populate the specs based on Deliverable type, but also allow the user to change specs if there is a need. I don’t Workflows will work because they will change any modified specs based on Type selected. I can, and may, set up new checkboxes for our standard deliverable types so if that’s selected the workflow is trigged.
Quick example, every project gets a WEB deliverable type. Those specs are typically 1920 x 1080, H264 codec, 35 mb/s, etc.
A client may request multiple WEB deliverables and may need one that is 10 mb/s. That’s what would break a workflow unless there’s a separate field as mentioned above.
