Creator and Amazon MWS?
Hi, I run an e-retail business and sell on Amazon.com and other marketplaces. Currently I run most of the business using Excel. I make updates to Amazon using CSV file imports from Excel, and also receive Amazon reports as CSV files. All my sales analysis, forecasting, P&L etc. is also done in Excel, driven by this data. As this involves a lot of repetitive manual work to import/export data, I'm considering moving to a database-driven system and am considering using Creator. I'd like to use the
Send Mail with a formated address Name <email@email.com>
I am not having success in formatting an email address in deluge, and have it sent using the Send Mail function I want to format as follows: John Smith <john@zoho.com> I can not seem to add the <> using deluge. is there another way of doing this ? In other words I want to personalize the address. is this possible ?
Using Fetch
I have 3 forms 'Add Employees' with user name and user initial, 'Add Property' with Property code and Managed By (this is a lookup of user initial) and lastly a 'Add Job' form which has some text fields, property code (lookup on Add Property.Property code) and Managed by text field. I am trying to auto populate the Managed by column with user initials when a Property code drop down values is selecte. Here is the code I have if (Add_Property[ID == input.Property_Code].count() > 0) { x = Add_Property
Cancel Submit Inside of If Else If Question - What happens?
What happened when Zoho encounters a "Cancel Submit" inside of If, else If validation logic? Does the code leave the If branch and abort the remainder of the code? I'm working on a stateless form and want to go through each field (about 8 fields) and insure the proper data is there, looking for nulls, duplicates, etc. I just want to be aware of the best way to abort the Submit at any point along the way, and NOT deal with the remainder of the checks down the code. EDIT: I now learn "Cancel Submit"
Multiple forms
We have several forms with one main form. We want to have the ability to show one of the other forms for data entry from the main form if they select certain criteria. I have not been able to get this to work
Subform not appearing in report, but is part of the form
I have a subform that is part of a main form. The subform appears on the main form and works. But when I open the report corresponding to the main form, there is no subform shown. What possible reasons could there be for the subform not to display on the report when it is visible in the main form? Sorry if this is a real basic question, but I am new at this. Thanks.
Recently check value in checkbox
Is there a way to get the most recently checked value in a multi select checkbox? I need to execute some code that depends on the most recently checked item in a multiselect checkbox. I have been trying to use list functions to figure this out. I seem to be having a problem where the order of the list is the same as the order of the check box field items. Another words as I check items off they always appear in the list in the same order as the check box field check box items are set up. I cant
Stateless forms, custom button, on click, not able to modify any form value
Hi, Using a custom button in a stateless form I am not being able to change the value of any field in the form through the "on click" script. Say for instance the script below. I am trying to clear the content of a pick list. The script does nothing at all. I have tried other type of fields like a simple line of text and still not able to make any change to it. If this is the case then what's the purpose of the custom button?? actions { Clear ( type = button
List functions, contains and distinct limitations?
Hello, I am trying to use contains() and distinct() and sort() functions but it seems there is a limitation in number of records these functions can handle? Look at this script for example, this is an iteration of distinct() function after I found it wasn't working: Note V.Categorias field is a text field with items separated by commas. Application link (in case you want to look at the actual code) Categorias_Lista = List(); for each V in Vectores { V.Categorias=V.Categorias.toUpperCase(); C=
Filter based on multi select field
Hi there I have the following 4 Forms System Access - User ID, User Email (both set by system), First Name, Last Name (input by user) Membership - First Name, Last Name, Licence (input by user, can be different to System Access) and a Lookup field to System Access form with multi select enabled. Nomination - Logged in User (set by system) Entry - Sub Form of Nomination, fields are Licence (choice field), First Name (text), Last Name (text) The end result I am trying to work out is that on the Nomination/Entry
MultiTenant subscriptions?
Is there any way that I could create an own-branded Creator app and then sell subscriptions to use it to multiple companies each of which might have 1-50 users? Could each company's data be stored, accessed and billed entirely separately? I get the impression that Creator is not really designed for this type of thing.
Pull a Zoho CRM contacts information into a Creator form .
I have added a Zoho CRM "look up" field into my form. The form currently pulls the contacts name. Is there a way to pull the email and contact phone number simultaneously into the form automatically from the same contact record?
Appending a apply now link to every record listing in a report
I have created a custom Job Database. I am displaying the results in a report form. I would like to append an apply now link (that takes you to the application) to every row. This way someone reviewing the jobs an applicant can click and go to the application. Any ideas how?
Another Android Issue? Subform With Calculated Expression.
I am finding that Android will not save parent form edits if a subform [on the parent form] contains a calculated expression (even if subform is hidden and disabled). If I delete the calculated expression in the subform, I can save edits to the parent form data. In my case I am using an if statement to display a character in place of true or false in a decision field found in the child form.
Noob Question: How to Use ResponseText
Hi All, I'm not a programmer, but can usually follow other examples to accomplish what I want. I'm having trouble understanding how to use data being returned from Google Distance Matrix API. I have 3 inputs: From_Address To_Address Distance Once someone puts information in the To_Address, I want to return the miles in the Distance input. I've set up getURL to Google Distance Matrix API and have a successful response back. I see that the data is stored in map.get("responseText"). Here is the complete
Smartphone/Tablet Options For Developers?
I've been playing around with Zoho Creator for a week now. I like it for the most part, as it has great potential to easily build multi-platform data-centric apps, easily and quickly. However I am finding a few setbacks here and there, and another is the presentation differences between iOS and Android tablets. It seems some "bar labels" aren't being handled correctly and it's difficult to know exactly what you're doing and where you are at. For instance, on Android tablet, when I view a report
Zoho Creator On Android
Hello, I was trying to get though to your support for the last 6 days, no one has responded. Since the last upgrade, my android users are having issues with numerous text fields while doing data entry. It seems like as the users type in some of the fields, the cursor resets back to the begging to the field. This literally causes text to be typed BACKWARDS into the fields. So if I type in MIKE, it turns out to be EKIM.... I cannot figure out why this is only happening to some of the fields. I
Can I call a custom function in the on user input of a field?
Dear All, Lets say that I have a dropdown (input.Dropdown) with 2 choices (Text A, Text B). I also have a single line 'Description'. I would like when I choose Text A then to fill the phrase 'Text A' in the single line. I know that I can do it in the on user input like this if (input.Dropdown = "Text A"} { input.Description = Dropdown; } etc. My question is if I can do it with custom function. Can I write custom functions and call them in the on user input? I know how to call functions in
Filtering Reports
Good day, Im filtering a report using Functionality based URLs , in my report I have a origin and a destination, its possible to use OR functionality? For example I want the report to show me the records if the origin is = "blue" OR the destination = "blue", Best Regards,
Is it possible to Convert or Delete a CRM lead from Creator?
I want to be able ton convert a CRM lead from creator, is this possible? If there is no direct way to do this I assume I would need to do the following: Create new customer record Create new Potential Delete CRM Lead I know how to do everything except delete CRM Lead. So basically i need to know how to either convert a CRM lead from creator or how to delete a CRM lead from creator. Please any help would be appreciated. Thanks Matt
How to pass lookup field value to another form.
Hello How can I pass lookup field value from form1 to form2? -Form1 and Form2 both has lookup field to form0. -Report of Form1 has custom action button which "openurl" of Form2. -When Form2 is called from Form1 custom action, I want to pass Form1's Form0 ID to Form2 as a default value. I tried like "openUrl("https://...#Form:form2" + "?form0=" + form1.form0, "Same window");" but form2's lookup field to form0 is null. How can i pass lookup field value in openurl method? Thanks Tadashi
Context Sensitive Menus
Is there any way to disable/enable Custom Actions in header and/or edit record menus? There are many situations where a particular action is inappropriate and it would be helpful to be able to disable it. If this isn't already possible nor in the development wish list then please add it.
Copying field for rows within subform
1) I have a string field called group names that I want to pull the same value from the previous row? Formula?
Null value handling in Subform
First, please accept my apologies for my poor English. The followings codes work perfectly for my main/sub form setup. Until when some records are carrying no subform records. I google for the solution for almost 2 days now. But I still have no glue. for each row in input.Shipping_Quantity { x = (x + row.Shipping_Qty_Packs); input.Total_Shipped_Qty = x; } Thanks!
Customer Portal Users Status
Hello, Kindly, Just a suggestion to add the Status (Active /Inactive) for Customer Portal Users Like Zoho "Users & Permission page" : Thanks, Omar Khamam
Narrow Column Report - Down - Over - Down. Possible With Creator Report Template?
Is it possible to take a very simple single field data set, create a report (template) and have the records go down the left section, then over and down the center section, and so forth? And perhaps put the report groupings in the columns, as well? Asking for too much? I've been spoiled on Microsoft Access the last 15 years, so please understand. Just trying to create a very compact "grocery store list" of checked items and don't want to use the entire page width to use 1/4 page width of text.
Add Application Name Variable in Report Template?
I can not figure out how to add a custom field that displays a system variable. Such as " = zoho.appname" to a template. I have a custom template (invoice type) that I'd like for the application name/version to appear. Is this possible?
Set Null Users Field
Good day, I have a function to create records with deluge insert into, inside the form I have a Users field (Customers), the problem is when the Record is created this field fills automatically with the loginuser info, even setting in the insert into instructions to set this field as null. What should be happening?
Find records for value in Multi Select lookup
Hi There We have a form (Case_Details) which has a Multi Select lookup to another form (Client) On saving a new Case_Details form we want to find any other cases that relate to any of the selected Clients on this new case. I have the following deluge script and the line highlighted bold is not valid for some reason clients = Client[ID in input.Client_Names]; email_body=""; for each c in clients { //find any other cases which are for the selected client matches = (Case_Details[Client_Names.contains(c.ID)
Bug: Insert into deluge script doesn't work on Mobile.
Hi, Insert into deluge script doesn't work on a standard form via the Zoho Creator Mobile App. I have shared the application with support: https://creator.zoho.com/johndobble/bugs/#Page:Standard_Form Please advise. Regards
Duplicate Allowed and Successful - When It Should Not
In testing my application, I have found that ... I have a form with a field that does not allow duplicates (LoadID) and is mandatory. However if I go to the record and select duplicate, the process will succeed and I will have a record with a missing LoadID, as well as the corresponding child records. Why is this? I can think of a handful of potential clients that may find the duplicate feature useful, but as it is, I will have to explain to all that "duplicate" can have unwanted results until such
Reload Dashboard from Iframe
Good day, I have a Dashborad and inside two iframes, one of those iframes I have a record edit, in the record edit On Success I have the following script, openUrl("DashboardUrl", "parent window"); When I update the record nothing happens, but If I use "same window" instead of "parent window" the OpenUrl work inside the Iframe, but I want to load the page in the Main window. There is any alternative to reload the main window Dashboard?
Iframe Record Edit OperUrl
Good day, I have a Page and inside two iframes, one of those iframes I have a record edit, in the record edit On Success I have the following script, openUrl("MyUrl"parent window"); My problem is that when I update the record nothing happens, but If I use "same window" instead of "parent window" the OpenUrl work inside the Iframe, but I want to load the page in the Main window, there is any alternative to do that?
using distinct function
I have a blank multiselect field called 'WO subtotals ' (WO short for Work Orders) I have subform Containing a WO Group field and an Est. Hours Field and a Create New Group Field in each row starting with a value of 1 in the 1st row in the WO Group field each new row will be also be 1 until I select 'Yes" in the Create New Group field of a given row, then that row along with all succeeding rows becomes 2 until I press it again, then it become 3 and so on I want the sum of Est. Hours for each
Show only "active" choices
I am developing a custom employment job board. I have created a webform where the HR department can create a "job posting". In the "job posting" form, HR can select active or not active for the job. When the applicant fills out the application form the "Position applying" field is a lookup field that relates to the job posting form/database explained above. Here is my question: How do I restrict the lookup field for only job postings that are marked "active?"
Fetching and displaying form data
So I have one form with supplier information, like name, location, contact, email...etc. Then I have another form with product information, like a product type (baby clothes, or adult tshirts..etc), a photo, price, and dimensions I related the forms together using a look on the product form, which looks up the suppliers name. So the plan is to goto trade shows, collect supplier information. Then take photos and capture details of all the products they are displaying. So what I need to do after, is
How to get a sum for "Total Points" based on "Points" entered for attendance and show it in the "Total Points" field on the same form.
I am a newby...so bear with me. I have a form called, "Employee Personal Data" for personal employee info. I then have a form called "Employee Attendance Record." On this form I have a field called "Points" to enter .5, 1, 1.5, 2, etc. as points for an absence. Once entered, I want the "Total Points" field on the Employee Attendance Record form to show the running total for the year for that particular person (up to 12 points total). I have a Lookup Field to pick the employee's name from the Employee
if statement at form 'on load' using lookup dropdown as criteria
cant seem to get this to work....please help if(TZ2WOF_PEs.!= "-Select-") { TZ2WOF_Select.deselect(); show TZ2WOF_PEs; TZ2WOF_Select.select.("PEs"); } fyi TZ2WOF_PEs is lookup field in dropdown mode TZ2WOF_Select is a checkbox Thanks in Advance
Stateless Forms Usage - General Questions
There is very little explanation of Stateless Form and how to manage their implementation in real-world application. There are some things I need to do that a basic report just can't do, and I can only guess that a stateless form is the only option, but then I come to find you can't do many basic things with a stateless form. Example, I have a form that gathers fuel purchases in both US and metric means. It stores date, location, odometer, and quantity. I need to be able to present the user with
Lost the ability to add new entries to dropdown linked to another table
Hi We have a form that allows the user to add new entries to another table if there is not an existing record in a dropdown list. But this seems to have gone now. Can someone explain how we can reinstate this please? Thanks
Next Page