-
UPPERCASE text on entire sheet without formulas
Having to have helper columns for every column in a sheet with formulas to change all text to UPPERCASE that is input through a form from other people makes my very large sheet ridiculously and needlessly larger - and then there is the problem of data shuttle which does not shuttle columns that contain formulas, so you…
-
Run Config Window for Data Shuttle
When you run a DataMesh, a window Run Config window appears that shows the number of rows that will be impacted for different types of things (i.e., New Rows). It would be helpful to have this for Data Shuttle as well. On more than one occasion the unique identifier mapping unexpectedly un-maps, and all the rows are…
-
Resetting Auto-numbering for columns in templates and sheets
Problem: When creating a template from another sheet with an column set to type auto-number, I have learned through technical support that you only have ONE chance to reset that column back to start number 1, and only by deleting the old column and creating a new one. If you make a mistake with the numbering schema, you…
-
Sheet Properties / Metadata - Column Count
Rows are numbered but columns are not. There should be sheet metadata available thru File / Properties that tells the user how many columns are in the sheet. This would be helpful for solution developers to know if they're approaching the 400-column limit without the tedious and error-prone task of counting them manually.…
-
Data Mesh Auto Map columns with identical names
if I'm using 36 columns in source and target sheets I have to touch all 36 columns in both parts of the Data Mesh Column Mapping. IDEA: if the column names are identical in both places, auto fill / match columns similar to what data shuttle does.
-
Data Mesh Multi-Column Match
I think it would be beneficial to have a multi-line match option within a data mesh instead of having to setup 2 different configurations. For example, attempting to match the values in two columns to meet the criteria to proceed would help if you happen to have a few duplicates in one of your columns, then the secondary…
-
Copy horizontal cells and paste vertically
It would be helpful to be able to copy horizontal cells in a row and past them vertically in a column. Sometimes when we get a lot of information from a form submission we need to be able to reorganize the data that comes through, and being able to format some of the data vertically within a column would be helpful.
-
Merged: approval comment upgrades
This discussion has been merged.
-
Merged: Approval Workflow with additional actions
This discussion has been merged.
-
Create Automation Rules with API
It would be convenient if we were able to actually create automation rules via the api rather than just modify. It would also be nice if the API automation functionality was improved, it's pretty limited.