Search results by user ID 7150

Re: Loop Through Table Does Not Return Values

Jack — Sun, 19 Jun 2016 03:25:26 GMT

Hi Ben,

I have a second issue. It appears that the workaround mentioned initially on this post that you confirmed was the only way to get a Table loop to work (run table loop, assign loop's recordID to AR, use AR in a Retrieve value from Table action) no longer appears to work. Instead, all the values I try to retreive from the table return blank, but apparently are not actually blank since they do not seem to register as empty when using a conditional statement that looks to see if they are empty or not. I have an action result that, before the lookup, have a value of 0 in it. The lookup is supposed to pass a value into the action result, and after the lookup, the action result is now blank.

This issue now prevents me from using a table loop entirely.

Sample issue can be found on the screen "Retrieve from Table Issue" in the Quotes App. A chain of action will run on page focus, inclusing the one with the table loop issue.

Any suggestions?

Unable To Parse Expression Issue

Jack — Sat, 18 Jun 2016 01:52:00 GMT

I am receiveing this weird message

During one of my set of actions. The screen has been copied. You can find it in the Reports app(previously called Archives). It is called "Unable To Parse Expression Bug".

THis bug took me all day to work on before I finally gave up. It is very odd. Oddly enough, If I put a show message action in my set of action the bug does not occur. But if I take it out, it happens.

I Essentially have a grid and a set of loop actions that use a start date and end date as criteria. Before those are ran, I use a dropdown to determine what the two date values are (the end date range is always Current Date/Time from session). I have six options. Three use the Date add function and a negative value, one allows for a custom entry using date picker controls, one grabs the first day of he year using the current date and a few date and math functions, and the last one grabs the first of the month using the current date and the first day of month date function. The last one is the one with the issue.

I have created a red button that will run the errenous code for you. Let me know if you need any more info.

Re: Looping Table does not respect the Order By field

Jack — Thu, 16 Jun 2016 19:42:46 GMT

Hi Mahlon,

I too am finding this issue problematic. You may not be able to use this workaround, but I have found one that works for me. Instead of doing a Loop Through Table, I made a grid with the filtering, sort and values I want, hid it, and the ran a Loop Through Grid action on that grid, which does respect the grids sort order. Its a pain in the butt as far as additional work, but it did acheive what I needed.

Re: Loop Through Table Does Not Return Values

Jack — Thu, 16 Jun 2016 19:30:55 GMT

Hi Ben, I have found a specific scenario in which I am having an issue. It appears, as mahlonf has postefd about (https://www.method.me/cs/forums/t/9581.aspx), that the Loop through Table Action's Order By setting does not work at all. regardless of what is selected, the results return in RecordID order. This is problematic because I want to look at a range of records by date and get the first date value and then the last date value.

I have posted a workaround to this issue on the above-mentioned post by mahlonf.

Re: Loop Through Table Does Not Return Values

Jack — Fri, 10 Jun 2016 17:11:52 GMT

Ok, good to know that I am not doing something wrong.

Just to clarify, the way I am doing it (use get RecordID from loop, use it to retreive values from table)is currently the best way to do so? I have a setup on the same screen I mentoned above that demonstrates how I am doing it.

Loop Through Table Does Not Return Values

Jack — Fri, 10 Jun 2016 08:51:29 GMT

I have a Screen, Loop Issue, on the Reports app that demonstrates my issue. I have one button that performs a grid loop(on a grid that has no views/filters), which worked just fine, returning six values. I have it set to show a message each time for easy counting. Right next to it I have a button that performs a loop through table (with no filter except Record ID is not empty). Unfortunately, this action does not return any values, but it does apprear to be going through each record as six sequential blank message dialogs pop up.

Setting the loop through table qaction to place the Record ID into an action result does not appear to work either.

However, there is a workaround, since it appears that Loop's Record ID (or Row.RecordID in message dialogs) populates with the correct value just fine, allowing me to assign it to an action result, use that action result in a Retreive Values From Table action and essentially acheive the same result, just with a few more steps.

I figured I would see someone else post about this so am I missing something here or am I the only one trying to use a table loop?

Re: Custom App and App Ribbon

Jack — Wed, 08 Jun 2016 01:39:37 GMT

That fixed it!

thanks again

Re: Custom App and App Ribbon

Jack — Tue, 07 Jun 2016 16:49:07 GMT

One more question:

How do I pre-populate the contact dropdown on my quotes page when a user clicks the new button for quotes in the app ribbon on the contacts screen?

Re: Custom App and App Ribbon

Jack — Mon, 06 Jun 2016 23:15:23 GMT

That was what I was missing!

Thanks Ben!

Custom App and App Ribbon

Jack — Sat, 04 Jun 2016 02:10:11 GMT

I am trying to get an app ribbon working for the Quotes app. I think I have everything set up properly.

On the contacts app I get a proper count but clicking on that app in the ribbon brings an error popop.

I will also need to know how to setup app ribbon New buttons, as asked on this forum post:

https://www.method.me/cs/forums/p/9442/31899.aspx#31899