Xml rpc update on a field in a form with subforms failed
Hi i am trying to update field in a form with couple of subforms. When i try to update the field after payment i get weird errors that are not related with the form i am trying to update, but instead it is related with subform in this form. I tried removing this subform but then it gives me same error with the next subform in the form. My question is, does zoho suports update on a form with subforms ?? Or this is some other issue. I checked the code multiple times and there are no errors in it. This
How can Admin see every record with zoho.loginuser active
I have a form that my salesmen use to ask for maintenance for our customers. I used a zoho.loginuser so that each salesmen can see ONLY his entries. Once they submit a form, I have to edit the entries in view mode, in order to let them see when I've processed their request. PROBLEM: I can't see their entries because I'm logged in too, but with my userId! So I could see only my entries (which I don't need...) Any suggestions?
System restore has not restored data
Hello, I have done a backup of my application 'KiwiOz Childcare.' I have then completed a Restore and renamed the application kiwioz_restore. However, in the restored application kiwioz_restore, none of the data has restored. I have also backed up and restored my other application (Cafe Nanny). This restore worked and the data was restored. Please advise, thank you (I have allowed edit access to support for both of these applications).
webhook keeps firing
My webhook keeps firing every 10 minutes, instead of just once. It is configured with a workflow action on create/edit that checks the existence of a (custom) field, and fires if it is true. The webhook service returns an empty response with status 200 OK. It completes in 10 seconds or less -- btw, what is the timeout on webhooks? It has fired 15 times now in the 2.5 hours since I "tested" it by saving a record, firing every 10 minutes with the same data. There is nothing listed in the errors tab.
How to sum up pre-added field?
Please see photo, i need to total every amount that is added on the subform. Hope you guys can help me asap. Thanks.
Issue with deluge script executing in a sub-form
Hello, I have a problem getting a deluge script to execute in a sub-form when editing the parent form. I have a parent form that contains a sub-form (master-detail relationship). I also have a deluge script that is intended to execute each time i add a row in the sub-form. The script executes well when creating a new record in the parent form. I am able to add as many rows as I need in the sub-form, and each time the script does execute as expected. However, the problem lies in when editing the
Separate out a comma separated list
Hi, I have a comma separated list of emails in a single field. I want to send 1 email to each email address summarising the information in the form. Eg Row Num Email recepients 1 test@test.com, bob@test.com 2 bob@test.com 3 Test@test.com 4 test@test.com I want Test to receive 1 email with 3 entries and Bob to receive 1 email with 2 entries. Constructing the email content is fine but I am having issues Extracting the emails from the comma separated field I don't think Zoho has an explode type function
Can't use dropdown form fields as display fields
Hi, I have a SERVICE subform that has a SITE look up field. I want the SITE lookup to display the site name and site address. However, when I go to Edit Field ->Advanced Options -> Display As, I do not see all the SITE fields. The ones that are missing are the dropdown fields so I cannot select site address. Note, site address is a dropdown in the SITE form. Is there a way that I can use the site address field as a display field in the SERVICE form without making the site address a textfield in the
Sending notification from one app using email ID of another
I need to send notification when data is entered in one application to the email ID of registered users of a different application.
Refresh Fields Within A Form Without Reloading or Submitting the Form
Is there a way to refresh fields within a form without reloading the form? Problem #1: I have a Jobs form. And I have a Contacts form that is linked to a contacts database. Within the Jobs form, there are two places to look-up contacts and add them into the Jobs form. But one of the places also allows adding a new contact. When I add a new contact at this place it does not appear in the look-up list for the other place. I need a field.refresh() option to refresh the look-up so I can see the
allow shared users to have edit or add permission to records
Hello, How do you give edit/add permission to shared users on your application. I would like to be able to allow users to add or edit records on certain form or view. I did not see any functions that allows me to do so. Please advise. Thank you
zCreator Emails are treated as junk by Microsoft Smartscreen Filter
Dear zCreator Team, I would like to bring to your kind attention that zCreator emails are being treated as junk by Microsoft smart screen filters. ---- Deepak Vasudevan http://www.linkedin.com/in/lavanyadeepak
Convert string to numeric?
Is it possible to convert a string or portion of a string to a numeric variable that can be acted upon in a function? E.g. I want to take a string like "5 - High", extract just the "5" substring and create a function to multiple that by a separate numeric value. Currently failing because the substring is still a string. Thoughts?
Layout of Charts and tables
Is there any way to have headings in a table or chart wrap so I can make the columns smaller but still read the headings.
toDate from Numeric Variables
I am trying to convert numeric variables to a date: curMonth = 2 curDate= 15 curYear = 2013 Date1= (curMonth+curDate+curYear).toDate() I have also tried Date1= (curMonth+curDate+curYear).toString().toDate() In my script i just keep getting error that it couldn't convert variable to a date. Can someone please help. Thank you.
Multiple Select List select/remove all
Hi, I have a Multiple Select List with the option to Search and Auto-Complete. Can you please enable options that allow a user to select all or remove all from the list? There are instances where a user may wish to select all the values from the list but at the moment has to click them all individually.
How can display pic in a Note Field
Hi Latha My application scenario is as follows： 1，I have a File Upload field in formsc 2,The pic can show in view 3,I now want to the image displayed in a plain field and put the code as bellow plain=("<img width='100' src='http://creator.baihui.com/DownloadFile.do?filepath=/" + r.zpct + "&sharedBy=" + zoho.adminuser) + "'/>" but I try many times it's dons't work,I don't know where is wrong, please help Thanks Stanley Guo 2013-3-14
How to edit a record in htmlview?
Hey - I know how to edit a record using standard Form/View URL, e.g.: /#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname> It works great while the <viewlinkname> is a standard view. It fails to work when I use htmlview as the <viewlinkname>. Any idea how can I do this properly using alike: <div elName='zc-component' formLinkName='newXYZForm' params='XYZType=<%=openFormAs%>&zc_Header=true&zc_SuccMsg=Data Added Sucessfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset'>Loading
Changes to the behaviour of the ZOHO Creator platform as a result of platform upgrades.
It has been brought to my attention that there have been one or two changes to the behaviour of the ZOHO Creator platform as a result of platform upgrades. 1) Incorrect indication of change to the Deluge commands. When editing an Application (in Free-Flow mode), any time a user types Ctrl+A (to select all Deluge commands) or Ctrl+C (to copy selected Deluge commands), the red star (asterisk) next to the 'Application+Event Description' in the title appears. This red star is supposed to appear
Separate out a comma separated list
Hi, I have a comma separated list of emails in a single field. I want to send 1 email to each email address summarising the information in the form. Eg Row Num Email recepients 1 test@test.com, bob@test.com 2 bob@test.com 3 Test@test.com 4 test@test.com I want Test to receive 1 email with 3 entries and Bob to receive 1 email with 2 entries. Constructing the email content is fine but I am having issues Extracting the emails from the comma separated field Getting the distinct emails from the list
For Each Records that was update in the last month..
Hey all im trying to run a for each into a HTML table, and although I can get the records based on a field values I also want to query the date modified, how can I ensure that i only get the records that were modified in the last month? Thanks in advance Adrian
Considering Creator for Application Development
Greetings all: I have used Creator off and on through the years for smaller, personal projects but am considering it for an online application to sell to end users. I like the scripting capability as well as the deep feature set, but I have a couple of questions what I hope a few of you can weigh in on. 1) How problematic has the updates from the Zoho team been in the sense of application stability? In other words, how often have your apps been broken by new updates that were rolled out without
Getting stonewalled on variable call
Hey, Is there any reason why my function would say my variable is "not declared" even when it's clearly in the script? If I try to save the following script it states just that for 'maxweek1': void schedule_teams.mhl_scheduling_module.toString() { for each r in MHL_Scheduling_Module [(Season == "Winter 2013" && (Team_1 is null))] sort by Team_1 { scheduleteam15 = MHL_Team_Contact_Info_Entry [((((Current_Last_Season_New == r.Season && Nights_Playing == r.Day) && Team_Name !=
First and Last day of the month
Hello, I have a form, where there are two date fields: 1st field) From Date 2nd field) To Date I would like On Loading the form the current values of these fields to be: From Date = The 1st day of the current month To Date = The last day of the current month How I could write this script??
Search Records script
So, I would like to create a simple Search tool on one form, upon user input of a name, records containing that name will be fetched. Problem is, I don't know script. I've tried the fetch on user input etc. but it's just not working out. If it is possible, I would also like those records to be updated automatically (multiple users inputting information- in real time update on all computers) Is any of that possible? and if so, how?
converting a complicated excel formula
Hi I have the following formula in excel which I can't seem to translate to deluge: =IF(AND(B3>2,C3>2),"MANAGE",IF(AND(B3>2,C3<3),"INFORM",IF(AND(B3<3,C3>2),"SATISFY",IF(AND(B3<3,C3<3),"MONITOR")))) I understand the AND needs to be translated to &&, but the multiple 'IF's and comments are the problem. e.g. where B3 is a user input ranked 1 to 5 (drop down list) and C3 is a user input ranked 1 to 5 (drop down list), should this be a comment script or a formula script? thx :)
Make View Filter Searchable
I have several views with an Auto filter. The pick list on the filter is quite large and it is making very cumbersome for the users to scroll down to find the item to filter by. Is there a way to make an auto filter searchable?? Thanks in advance.
Related Tables
In general my question is the following: I am developing a Housing application. I have rooms, occupants, and occupancies. These are the 3 core tables of the application. These tables are related in database terms - in that there are 'foreign keys' in each of the tables. Can this be accomplished using Zoho creator. Thanks Tom Hirsch thirsch
Dynamically summing a field of a subform
Hi, I have a subform of invoice items held in a main form of invoices. When the form is loaded, all of the items (ItemCosts) are added up and the figure is loaded in the SubTotal field of the main form using: input.SubTotal = Invoice_Items[InvoiceID == input.ID].sum(ItemCost); This code will not help with any changes made to the open form using 'InvoiceItems > ItemCost > On User Input' as the code is working on the main database and not the open form. How do I access (and sum) all the items in
Want to create a second form to enter data for the same table (duplicate form)
This sounds like I want to create a duplicate form . . . but . . . I have read that thread about copying the script and pasting into a new form and that is not what I want. I want to be able to edit the same table information with two different forms. One will enter all the data fields and one with be a 'quick entry' to enter just a few of the fields which will later be edited on a view in order to enter all the data. Thus the two forms will be working on the same table, not two identical forms
User Add Choice to Pick List Field
Can you provide preferred methods of enabling a user to add a "Choice" to a pick list (a.k.a. Multi Select or Checkboxes Field Type)?
How can I create a hierarchical multi-select or checkbox field?
How can we produce / display a hierachical multi-select field? E.g., "Cars" might look like: Acura - MDX - TL - TSX BMW - 330 - 335 - M3
Total a check box field
I have a form called Register It has a checkbox field called Events_Open and a Net_Amount field for the total. The data for the checkbox field comes from a form called Events with field names of Event_Name and Event_Price. Event_Name is a calculated field holding the value of a dropdown called Event_Product. In the On User Input of the Events_Open field is the following code: //Set the initial value of Net Amount input.Net_Amount = 0; //Fetch the amount for the selected items and calculate the Net
Problem with a disabled lookup field
Hi All, I have a Form (Master) with 3 fields: Type , Color and Thickness. This Master Form has a SubForm with 2 lookup fields (SubColor and SubThickness) referencing "Products" and another lookup field Sr_Num referencing "SerialNumberHolder". On selecting of 'Type' 1. Filtering the 'Color' Values 2. Filtering the 'Thickness' on user input of 'Color'
Need help scripting toString Function - Pretty stumped
Hi, I'm working on an automated scheduler function to fill out teams into game slots in an ice hockey league season. I want to have one game per team, per week, based on the criteria supplied in the team lookup field that "Team 1" is based on in the code below: void schedule_teams.mhl_scheduling_module.toString() { for each r in MHL_Scheduling_Module [(((Season == "Winter 2013" && Reverse_Record == false) && (Team_1 is null)) && (Team_2 is null))] sort by Team_1 { scheduleteam15
Wow, I really need a 12 hour time format!!
Doing an on-line schedule of events with Creator and it works great except that time can only be displayed/chosen in 24 hour format. Which most people don't understand. So I opted for a dropdown list where they could choose the time in "text" (1 am, 2 am, etc.) But that won't sort properly! When you try to sort by time, it lines up all the 1 am events followed by all the 1 pm events, then the 2am events and the 2pm events! Oh no!! Can we please have the time in 12 hour version too? dustylinden
PayPal Usage Question
Can the PayPal payment data be queried just like any other table? If I wanted to find all payments where payer_email=zoho.loginuserid, would this work? Thanks, Jeff
Cannot add fields to a form
I have been trying to add new fields to an exiting form. I can drag and drop the fields into the form where I want them, edit the field names, etc. but when I access the application, they are not there. I have tried this with a variety of field types and none get saved to the form. I am able to changing the titles of existing fields. I thought it might be a temporary problem, but it has persisted for nearly a week. I wrote to the support email address, but have not received a reply. The application
Audit Trail / Change Log
Admins need to be able to create a report on a table/form that lists all changes by date, user, and value. There are some ways of kludging this into an application, but this should be a native function supported by the Creator back-end.
How to Hide a Sub-Form
How do I hide an entire Sub Form based on a conditional statement?... Not just a couple of Fields on a Sub Form?
Next Page