Hi
I have a data source which I used to build the form, I need the form inputs to be updated in a certain sheet and to keep the data source intact
please help me
Rizik Hilan
HI @rizik_Hilan
You can reference your data source from your other certain sheet/table so only your other sheet/table is updated when adding a new record. You will need to build a new form from your certain other sheet , not the data source sheet. If this is not what you need , please provide more information about your app thanks.
Hi Lynn
Thanks again, I will explain more, I have data source contains several columns some of them has preset values and some their values will be updated in the form. when the form updated then updates will not be done on the data source, instead it will be added to another file
Regards
@rizik_Hilan
Ok, did you try using an action to update another table?
Yes I tried, it will work but the data source will be updated as well, I dont want the data source to be updated
Hi Lynn
is there a way to call you ?
Youโll need to base your form on the โcertain sheetโ and use the โdata sourceโ to provide initial values to the form. Your form should not be based on the โdata sourceโ
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |