Re: Sharing an app prototype and a database in thi...

Thulium · 02-12-2025 07:32 AM

Hi.

I help an ngo and made my first attempt with Appsheet today. The result is very promising.

Of course, there are questions.

Sharing with the community
How can I please share an app prototype and the corresponding database here in the community?
I have "deployed" the app. The link is: https://www.appsheet.com/start/0d9b20e7-a481-429a-bc9b-95e8fc7a329c
If I am logged in as the owner, I can open it as expected.
But when I am logged in with my private Google account, I get an error message "Access denied".
Initial value
For a column "DateOfEntry" I have set for "Initial Value" : _ROW_TIMESTAMP
Nevertheless, this value is not automatically entered when I add a new data record
Automatically enter logged-in user
For a column "Reporter" I have set for "Initial Value" :USEREMAIL()
That works. But I need the user name.
"Initial Value" :USERNAME()
That does not work. Is that known bug?
ToDo/Done
The column "Done" ist set to type: "Yes|No".
How can I ensure that "No" is pre-entered and how can I change the word "No" or "Yes" to the corresponding words in German?

I would appreciate your help : ) Thank you.

WillowMobileSys

@Thulium wrote:

How can I please share an app prototype and the corresponding database here in the community?

This depends on how you have login security implemented. See image for settings

@Thulium wrote:

For a column "DateOfEntry" I have set for "Initial Value" : _ROW_TIMESTAMP

You want to use the TODAY() or NOW() functions

@Thulium wrote:

For a column "Reporter" I have set for "Initial Value" :USEREMAIL()
That works. But I need the user name.

You should also get USERNAME() IF the user is logging in with a provider that supplies it. However, there can be issues depending on how you are using the value. It is highly recommended that you build and use a Users table instead. Then lookup the UserName from this table based on the logged in USEREMAIL() .

@Thulium wrote:

How can I ensure that "No" is pre-entered and how can I change the word "No" or "Yes" to the corresponding words in German?

Set the "Initial Value" to FALSE for "No". There is a whole section called "Localization" devoted to app-wide text that you can modify into your preferred language. See Image.

Steve

@Thulium wrote:

How can I please share an app prototype and the corresponding database here in the community?

Share sample apps in your public portfolio

For a column "DateOfEntry" I have set for "Initial Value" : _ROW_TIMESTAMP

_ROW_TIMESTAMP isn't a thing. Set Initial value to NOW().

"Initial Value" :USERNAME()
That does not work. Is that known bug?

Not a bug. Read the help doc.

How can I ensure that "No" is pre-entered

Initial value

how can I change the word "No" or "Yes" to the corresponding words in German?

Thulium

"Share sample apps in your public portfolio "

I followed the steps. But @AlexMtold me, that he has no access.
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Name-of-table-of-database-does-not-update-itsel...

Thulium

@Steveand @WillowMobileSys

Thanks a lot for your helpful answers : )

"Share sample apps in your public portfolio " (sorry for my quotation marks. the command quote inserts my entire posting)

I changed the settings. Can you access my prototype app now?

"Set Initial value to NOW()."

I like to set the value to the date of the creation of the data row. It should not be changed, when you edit data later. Is it true, that I only need to set the edit option to "false"?

"initial value = No"

Works fine. So simple : )

Tomorrow I will go through the other points.

Thulium

Workaround for Username
"You should also get USERNAME() IF the user is logging in with a provider that supplies it. However, there can be issues depending on how you are using the value. It is highly recommended that you build and use a Users table instead. "

OK, I willl follow your advice.

I have now created an additional table where I map email addresses and forenames.

https://www.appsheet.com/start/0d9b20e7-a481-429a-bc9b-95e8fc7a329c

What did I try?

LOOKUP([taReporterEmail], "TABLE_Reporters", "reEmail", "reForename")

It works : )

TABLE_Tasks
taTask
reReporterForename
taReporterEmail
taDateOfEntry
taDone

TABLE_Reporters
reEmail
reForename

Localization
"how can I change the word "No" or "Yes" to the corresponding words in German?"

Works fine with the localization. What a nice feature : )

Alternate GUI elements for "yes/no"
Are there options for other visualizations of "yes" "no", e.g. a switch "on/off" or a checkbox?

Steve

@Thulium wrote:

I like to set the value to the date of the creation of the data row. It should not be changed, when you edit data later. Is it true, that I only need to set the edit option to "false"?

Either set the Editable? expression to FALSE or just disable Editable?. I would disable it.

Thulium

Thanks @Steve
I will disable it.

May I ask again how to share an app here in the community? The method you suggested did not work. Please see my screenshots.

"Require sign-in" cannot be switched off. After switching it off and "Save" it switches to on by itself.

Steve

You'll need to talk to your Google Workspace admin about this. They've set limits on your ability to share your apps.

Thulium

: ) I am the admin.

I just need to know the complete list of steps to share a an app here in the community.

Steve

I'm afraid I know nothing of Workplace policies, so I have no guidance here.

Thulium

Thank you @Steve

I will try to get an answer via AppSheet-Support.

What I found until now:

If I deactivate the security option for AppSheet "Login needed" in Google Workspace, then sharing is possible.

But I don't want to deactivate this globally (i.e. for all apps). It should only apply to selected apps that I want to share with you here. Let's see if there is a solution.

Thulium

@Thulium wrote:
Sharing with the community
How can I please share an app prototype and the corresponding database here in the community?
I have "deployed" the app. The link is: https://www.appsheet.com/start/0d9b20e7-a481-429a-bc9b-95e8fc7a329c
If I am logged in as the owner, I can open it as expected.
But when I am logged in with my private Google account, I get an error message "Access denied".

The answer with all steps:

Google Workspace Admin Center > Apps > Google Workspace > Appsheet > Security settings for AppSheet Core licenses > (x) Turn off AppSheet Core security
Create an app
Open the app > Tab Manage (in the left sidebar) > Deploy the app > Move app to the deployed state
Open the app > Tab Security > ( ) Require user signin? > (x) Yes, the data in this app is public | (x) Yes, I am authorized to set up an insecure app

I asked AppSheet Support whether it is really necessary to deactivate AppSheet Core security globally. Unfortunately yes.

Whether there is also a way to share an app here so that all views can be used and also the input form, but it is not possible to send data: I don't know.

I also don't yet know how to ensure that the database can also be shared.

yasarcan

hi

Sharing an app prototype and a database in this community?