Ability to upload table definitions, and column settings, as json files or yaml file

[Daniel_Turner]

The amount of time it takes to change table settings, column valid if formulas, show if, etc… is so frustrating. It would be easier to define the setting in a json format and upload.

[Marc_Dillon]

[Marc_Dillon]

This google sheet comment JSON stuff will auto-populate if you use the Google Form to Appsheet conversion tool, if you need that for examples. That is unless they stopped doing that, been a long time since I used it.

Daniel_Turner:

you can not use this method to update settings?

It’ll update when you do a regeneration on the table, which will also wipe out any setting edits that you made in the editor that aren’t reflected in those cell notes.

[mcopp0315]

LeventK:

Attributes_4{ Type = Enum
TypeAuxData = {
  "EnumValues": [],
  "AllowOtherValues": true,
  "AutoCompleteOtherValues": true,
  "BaseType": "Text",
  "BaseTypeQualifier": "{\r\n  \"MaxLength\": null,\r\n  \"MinLength\": null,\r\n  \"LongTextFormatting\": \"Plain Text\",\r\n  \"IsMulticolumnKey\": false,\r\n  \"Valid_If\": null,\r\n  \"Error_Message_If_Invalid\": null,\r\n  \"Show_If\": null,\r\n  \"Required_If\": null,\r\n  \"Editable_If\": null,\r\n  \"Reset_If\": null,\r\n  \"Suggested_Values\": null\r\n}",
  "EnumInputMode": "Stack",
  "Valid_If": "=SELECT(Tags[DELIVERY],ISNOTBLANK([ID]))",
  "Error_Message_If_Invalid": null,
  "Show_If": null,
  "Required_If": null,
  "Editable_If": null,
  "Reset_If": null,
  "Suggested_Values": null
}

@LeventK @GreenFlux

Hi guys! Sorry to jump into an old thread, but this has already addressed 99% of what I’m looking for…

Using the ‘note’ feature in Google Sheets is about to be a lifesaver for me as I need to duplicate an app for about 20 different clients. Manually setting so many complex column structures is a nightmare!

I have made this work for a number of different attributes EXCEPT column formulas. This is where I’m stuck:

AppSheet:{“IsRequired”:false,
“Type”:“Number”,
“AppFormula”:“LOOKUP( [Email Address], “Subs_Jojo_Roster”, “email”, “Target TRAINING Carbs” )”
}

The settings for IsRequired and Type will translate to AppSheet correctly, but I cannot get “AppFormula” to generate. I’ve tried several variations with no luck

Could you provide any insight here? Save me 40 hours of time lol
Thank you all so much in advance!

[Marc_Dillon]

Your inner quotes are breaking the outer quote of the JSON string, and creating an invalid JSON object.

Try changing all inner double quotes to single quotes (the top arrows).

[mcopp0315]

@LeventK @GreenFlux

You got me very excited, but no luck… The whole string still just shows up in the Description field. Regeneration doesn’t manipulate the column structure at all once the line for “AppFormula” is added in the mix.

Any other thoughts? This seems like it could be such a powerful tool

[lamontfr]

Here is a feature request for a simple but powerful solution to upload column settings and much more, using json files. Hopefully in the future this will be implemented in AppSheet.

App Component Reuse Solution Feature Requests

1. Summary We would like to take a subset (Data, UX and Behavior) of an App and be able to reuse this subset into another existing App quickly and reliably. (See example in figures 1 and 2). We propose a solution which is much faster and safer than replicating each single change by hand. (See Figures 3 and 4). The solution is intentionally simple but it is powerful, flexible and fairly easy to implement. There is no hidden magic, the App Author is in control of every step. [export01a] [i…

[Roderick]

There are some unofficial workarounds for this, but I get your frustration. There isn't a fully supported solution planned in the near term, but the team is thinking through ways to address the functionality need.