Question i’m hoping you can help me with.
So we currently have a large input form with table columns as follows:
The idea is that the user enters input data into the “Op1Input” column and this is timestamped in the “Op1InputDate” column.
As soon as data is entered into the “Op1Input” column, the column is hidden and replaced with the “Op1InputText” column, which is a Show - Text column type which displays text to the user along the lines of “Text [Op1Input], Timestamp [Op1InputDate]”
All is set up and working as expected.
We are currently looking at ways to optimise the app to reduce sync times, and were thinking we could potentially replace “Op1InputText”, “Op2InputText” and so on with just one column, “OpInputText”. This would then contain a formula along the lines of:
If [Op1Input] is not blank, show text for op1
if [Op1Input] is not blank and [Op2Input] is not blank, show text for op1 + op2
We have a large number of input fields for the above, anywhere from 30-50 operations, so the above would obviously reduce the number of columns in the app quite considerably. It would however create a pretty large formula for the [OpInputText] column.
I was wondering what users thought was best practice to reduce sync times, have one column with a large formula or multiple columns with much simpler formulas?
Or would both methods be pretty much equivalent?