Skip to main content
Participant
March 2, 2016
Question

Editing multiple text fields at once

  • March 2, 2016
  • 1 reply
  • 876 views

I am creating an order form that has 164 lines (multiple pages) and I have three rows I need to work with.

1. Unit Cost - this value will not change, but I need to be able to input it all at once, so I can then reference it in the calculation column later on - How can I add values to multiple text fields at once?

2. Qty - This column of text fields allows the user to add in a quantity value (expressed as numbers) - How can I edit the format of multiple fields at once to make them all numbers?

3. This last fields calculates as 1. Unit Cost multiplied by 2. Qty to get the value. I want to setup this function for multiple fields at once? Is this possible?

Any help would be greatly appreciated. Having to format over 160 fields x 3 is a huge task.

There has to be a way to make this faster.

Thanks,

John

This topic has been closed for replies.

1 reply

try67
Community Expert
Community Expert
March 2, 2016

This is all possible, but requires using custom-made scripts. Especially setting the format of multiple fields is tricky...

Participant
March 2, 2016

So do you think it is worth exploring to do create these custom made scripts vs. doing it manually?

I wouldn't know where to start.

try67
Community Expert
Community Expert
March 2, 2016

I think so, yes. You'll have a more consistent form with less chance of mistakes that way. It will also be much faster to set up, if done correctly.

If you're interested in hiring someone to write the code for you instead of trying to do it yourself, feel free to contact me privately via PM or at try6767 at gmail.com.