Profile

Cover photo
Randy DeMoville
Works at International Baptist Church at Dumaguete
Attended Hyles-Anderson College
73 followers|914,085 views
AboutPosts

Stream

Randy DeMoville

Bugs, Issues, Errors  - 
 
One of our users of the app is experiencing a problem that I have witnessed with my own eyes...

When there is a referenced list view under a form view, it shows items and then has the "details" and "new" links... in this case it is an empty list still... so we want to tap "new" to go to the form to add something. However, the link does not take him anywhere on his ANDROID phone. Works perfectly on my IPHONE.

It had worked in the past on his phone, but the pencil is also at the bottom right of the screen now, and I'm wondering if that has something to do with it. The pencil does take him to edit the form. So tapping is working on his phone, it's just the "new" link that does nothing when tapped.

Any ideas/help?

Thank you.
1
Bellave Jayaram's profile photoRandy DeMoville's profile photo
2 comments
 
The person that was having this problem had to actually remove and reload the app today... not sure yet if that solved his problem, will check tomorrow.
Add a comment...

Randy DeMoville

Need help with ...  - 
 
Can someone explain why the "row header" is not showing up but the actual "key/id" and there is a yellow triangle with an exclamation mark in it. I can't figure out how to get the "row header" to show back up. Help please.
1
MultiTech Visions's profile photoRob Middleton's profile photoRandy DeMoville's profile photo
5 comments
 
Yes, that was my problem.
Add a comment...

Randy DeMoville

Bugs, Issues, Errors  - 
 
We are having problems with a number of our apps. It is sporadic but increasingly troublesome. Sometimes it just hangs. Often it is just crashing. Other times we are getting messages that it can't load the template. There is no particular reason or rhyme to it; it has just slowed down extremely even with an app that has basically very little data in the sheet.

Any insight? Big issue being worked on right now?

Apps in particular: HACPHACADEMICS-50225, IBCDSUNDAYSCHOOL-50225-164236

But really it's all of them. Thanks for any help that can be provided; I'm working to get my folks excited about using these apps, but the initial rolling it out is not very impressive when these problems are occurring.
1
Randy DeMoville's profile photoCarl Mahler's profile photoPraveen Seshadri's profile photo
12 comments
 
+Randy DeMoville, +Carl Mahler, just did another update. Should be somewhat faster now.
Add a comment...

Randy DeMoville

Bugs, Issues, Errors  - 
 
Is anyone else experiencing this? Just in the past couple of days I've seen my app error out over and over again... seems to be connection issues with google sheets. Today, this is showing up...

Wow, this file is really popular! Some tools might be unavailable until the crowd clears.

Not sure what would be causing this, but it's random. I'm the only one working on this file through AppSheet, so don't understand the "overload."
1
Randy DeMoville's profile photoPraveen Seshadri's profile photo
3 comments
 
+Randy DeMoville, I suspect the overload comes from too many request from the AppSheet service to Google Drive in a specific short time window. Google has increased our quota in the past, but this may be an aberration on their side or something wrong on our side. We've reached out to them, but in the interim it is certainly frustrating and a bit worrisome to us.

We see this error ourselves maybe once in 50 to 100 accesses. Typically when doing something like an app copy and nly rarely when refreshing an app in the editor. Are you seeing it much more often?
Add a comment...

Randy DeMoville

Bugs, Issues, Errors  - 
 
Think I've found a bug.

I have a ref column which is "required."

That column also has a valid_if which appropriately can end up being an empty list. When it is empty, it does not show up in the form at all. The form loads and if I click "save" it adds a row to the sheet with the "required" column empty.

If I could have it my way, I'd like to keep the "new" link from showing if certain conditions are met. Otherwise, if the form must show up, it should fail if the required field is empty.
1
Oliver PT's profile photo
 
not sure on the bug side of things, but as a work around until it's fixed you could have a "none" or "n/a" option. Then at least the field won't be empty and should avoid the sync data loss issue.. then once that is rectified you could just go back and remove all of the "none"s or "n/a"s
Add a comment...

Randy DeMoville

Need help with ...  - 
 
Could use some help with populating a drop down. I'm wanting to filter the drop down on the page based on a hidden field (an ID) which should limit the names in the drop down.

Currently, I can use Enrollment[Student Name] and it populates the EnumList just fine with multiple selections and saves them as a comma separated list.

But if I try to populate the EnumList with Lookup([Schedule Id],Enrollment,Schedule Id,Student Name) it will not work.

What is the difference? I just want to show only the student names for those enrolled in the class.
1
Randy DeMoville's profile photoAleksi Alkio's profile photo
18 comments
 
Now it's a little bit difficult say more detailed advices, because it seems to be little complex.. and I mean without seeing the app.
Add a comment...

Randy DeMoville

Need help with ...  - 
 
OK, I have a situation that I could use help with.

Using Valid If, I have been able to limit the names that show up as options to select from so that the same person cannot be enrolled twice in the same class. Works perfectly when adding a new enrollee. However, the problem is now if we attempt to EDIT that same record... when I go to submit any changes, the same Valid If that works great for adding is telling us that the field is "Invalid."

SELECT(Students[Student Name],IN([Student Name],SELECT(Enrollment[Student Name],[_THISROW].[Schedule Id] = [Schedule Id]))=FALSE)

So, the question is, can I have the "valid if" recognize we are editing and not adding so that it does not give this error? Is there something to add to the valid if statement to INCLUDE the row's previously stored value as valid?

Any help would be greatly appreciated.
1
Randy DeMoville's profile photoAleksi Alkio's profile photo
3 comments
 
Without knowing your case deeply, I would propose to use IF statement.
Add a comment...

Randy DeMoville

Need help with ...  - 
 
I know we can show / hide columns based on criteria. It would be very nice if I could use criteria to show / hide the ability to add a new row.

If based on the current useremail() for instance I can assign if the person can only update / if they can add records.

Does this exist and I am just missing it? Or is this something that could be in the works?

Same type of options could be employed for example to leave a record open for updates unless it has been marked "closed" in a column and then it is not longer editable (not just greyed out - but no option to "edit"). 
1
Glenn Ullerup's profile photoAleksi Alkio's profile photoReza Raoofi's profile photo
8 comments
 
+Glenn Ullerup​​ Editable_if only works after you have already tapped/clicked on Edit button and form turns into data entry mode, then you could prevent individual columns from being edited, but if you want to hide the Edit button conditionally, that is not possible, unless you have a separate slice that do not allow edit.
Add a comment...

Randy DeMoville

Feature Requests  - 
 
Slice of a slice. (For those who don't want so big a piece) :)

If we've already filtered from the table a slice based on criteria, but then want to further filter without re-creating the whole slice, it would be nice to reference a slice instead of a table. Just a thought.
1
Aleksi Alkio's profile photoBellave Jayaram's profile photoRandy DeMoville's profile photo
3 comments
 
What I am doing doesn't "require" what I'm asking, there are workarounds or just recreating a slice - slightly different.

What I was thinking was if I create a general slice that keeps certain columns from being visible and only those after or before a certain/current date. This is a full list.

Then if I wanted to have a slice that was limited to let's saw where the USEREMAIL matched a column in the slice to limit the slice even further.

Certainly I can just adjust the formula easily enough to do that.

My suggestion was just that if I could select an existing slice, I would not have to go back through and select or deselect certain columns if it had already been done previously.

Just being lazy :)
Add a comment...

Randy DeMoville

Feature Requests  - 
 
It would be wonderful if format rules could be applied to a slice, not just the table. So that in certain views if a criteria was true the format would change, but not so in other views. Any thought to this?
1
Oliver PT's profile photo
 
Following this one!
Add a comment...

Randy DeMoville

Bugs, Issues, Errors  - 
 
Any idea why a referenced dropdown would show the row label in the emulator on the appsheet site, but show the uniqueid on my iphone?
1
Philip Garrett's profile photo
 
+Randy DeMoville 

Please try the following:

1. Sync the app on you iPhone.
2. Close the AppSheet app from the Task Manager on the iPhone.
3. Restart the AppSheet application on the iPhone.

If that does not resolve the problem, please let us know.
Add a comment...
 
Another day another problem :)

What would cause a date field to show up as a 5-digit number "42117" for today's date.  It is getting the date through a ref... so it shows as the formatted date when selected, but when it displays in a list it is this 5-digit number... in the spreadsheet it shows up as a correctly formatted date.

It appears to be fine with a new input, it displays correctly in the list... but when I sync, it changes the value (in the app), although it appears as the correct date in the spreadsheet.  Very odd.
1
Philip Garrett's profile photoRandy DeMoville's profile photo
11 comments
 
Phil, thank you!  It seems to be working fine.  Thank you for following through on this.
Add a comment...
Work
Occupation
Missionary Pastor
Employment
  • International Baptist Church at Dumaguete
    Pastor, 2011 - present
  • First Baptist Church of Hammond
    Pastoral Staff, 2010 - present
  • Hyles-Anderson College
    Faculty, 2004 - 2011
Basic Information
Gender
Male
Story
Tagline
Pastor of International Baptist Church at Dumaguete, Negros Oriental, Philippines
Bragging rights
Graduate of Hyles-Anderson College, Missionary in the Philippines
Education
  • Hyles-Anderson College
    B.S. Missions, Master of Missions
Links
Other profiles