Yeah, this is the reason why I always tell people to use screen/user profiles column to do these, or have a hidden entry to write a default value.
1 Like
The issue I have with that is the sheet I need to set column value is not the destination sheet of the form but another table altogether.
@ThinhDinh Do you have a recommendation for my case?
If I have to Iâll use Integromat but itâs going to introduce quite a delay.
I would resort to a custom form and just do an add row + set column combo.
2 Likes
If Default Add Form + Set Column stopped work recently(however everyone agrees that it should work), why are you so confident that âAdd Row + Set Columnâ combo will work always?
@ThinhDinh
Okay, just created âAdd Row + Set Columnâ approach, and voila, it also doesnât work.
In this test application, I Add Row which uses relation and user hour rates to calculate sum of work.
With Set Column I âfreezeâ calculated value to Basic Column. So it can be accessed in Google Sheets.
Whatâs your settings here for the whole flow?
Eric was asking for a way to set column in a different sheet, not the destination sheet, I see you have âthis itemâ for the set column action and that was not what we were talking about.
I was also talking about a custom form with entries writing to user-specific columns, just to be clear, not a normal form.
2 Likes
Yes, I use USC. Maybe you can think of other approach?
In your custom form, the action attached to the the âCommitâ button looks like this:
That extra Set Column Values step should not be necessary. That is, you should be able to calculate the âFreezed Sumâ amount based on the selected owner, and then set that column together with the previous Add Row step.
This is one of the big advantages of using custom forms. It presents the opportunity to pre-calculate additional values and include them with the Add Row action.
Here is a copy of your app that demonstrates what I am talking about:
All I did was to create a relation to the users table with the value in the usc/Owner column, and then altered the lookup columns to use this relation. And that allows the âFreezed Sumâ to be calculated and included with the Add Row action.
1 Like