Mobile datepicker won't select February dates
I have a datefield in a form that has a problem selecting a February date on a mobile device. It automatically moves the date to the same day in March. Selecting a date in January or March does not show this behavior. There is very little code in the 'on user input' that just updates another date field: // update the end date row.End_Date_Time = thisapp.com.addDuration(row.Start_Date_Time, row.Duration) ; row.edited = true ; Selecting a February date using a PC does not have this problem either.
How to use api response string
How do you go about reformatting or getting values from an api response value? I used the Lead Convert method to convert a crm lead to a potential and create a contact. I get the following response: {"responseCode":"200","responseText":" \n710378000007272009<\/Contact>710378000007272011<\/Potential><\/success>\n"} How can I use this response? I know that 710378000007272009 is the contact ID I know that 710378000007272011 is the potential ID But im not sure how to get these values out of the
How to import data in a blank subform?
I would like to ask you if there is any way to import data in a blank subform. I have the following excel file I created a form with a blank subform like the following (with exactly same field names) then I clicked the Import data (it shows that everything is ok) but in the report shows me 3 empty records. Why this happens? How can I add these 3 records in a blank subform and to show them in a single record in the report (as we know, whatever we add in a blank subform it keeps it as a single record)?
Notifications from form entries not being sent
I set up the contact form to email me and it does not.
Scheduler substituting variable for Added_User
When I run the below code from the scheduler, it ignores the value for UserName and inserts the UserName for the Admin user. I should point out that this is part of a function that I am calling from the schedule. Is this a known limitation of the Scheduler or is it a defect? insert into My_Form [ Added_User = input.UserName Email_Address = input.Email_Address StartDate = tempStartDate EndDate = tempEndDate Status = input_Status
Calling up a form in Edit mode via Deluge
I am hoping that This might save someone from the hours I wasted yesterday Zoho Creator team might enhance the documentation to make the following more clear! The Creator help files at https://www.zoho.com/creator/help/views/editing-records-via-record-id.html#Invoking_the_url_from_Deluge_Script tell us that the syntax is: openurl("http://creator.zoho.com/"+zoho.adminuser+"/"+zoho.appname+"/add_contact/record-edit/contact_view/" + input.ID + "/","same window"); However, there are traps for the unwary!
Calculate Current Balance
I am woring on an application that is an accounting ledger for a bank account. I would like to calculate a running balance based on the date of the transaction for the individual. Does anyone have any thoughts on how I can accomplish this? Here are some details: I am uploading the following data: - Account Number - Posting Date - Transaction Amount I will also put in a beginning balance for each individual as a starting point called: - Beginning Balance Any help would be greatly appreciated..
Specific number of digits in number field
Hi, I'm trying to set a number field to only accept a specific number of digits. I wanted the field to accept 10 digits but give an error message if more or less are entered. I would also maybe like the form to return an error if they try to submit it without ensuring the correct amount of digits. Thanks in advance for any help.
iOS and Android - Subform With Image Workaround??
I have a big problem with my application when it comes down to accessing it from tablets and smartphones. I undertand (I guess) Zoho Creator's current inability to serve up subform data (child records data) to small device users where an image field exists in child subform. Frankly I don't like dealing with subforms anyway, which is why all subforms are disabled and hidden on main form add/edit load and I never add/edit child records via subforms from the main form. Question: Why, if a subform
input data into url field
Hello. I want to add a url link to a record so my clients can click and open another webpage and view relevant data. The webpage I want to direct them to has the same basic url with a unique 4 digit file number for each set of records. So let say the url to be used is "www.myrecords.com/file=". I then need to add "#3245" as the unique file# to give a link of www.myrecords.com/file=#3245" and add the url link name "Click for records". So I add a url field with link name option selected. I add a second
Fields with dynamic lookups not working in reports
I have a simple Region - Country lookup working in forms, whereby the selected Geographic region filters down the list of Countries. This works fine in forms, but not in reports. If a report is displayed in List View, everything is fine. However, in Spreadsheet or Grid view, the Country field is blank. The dynamic lookup also does not work there. The list of Countries is empty.
Calendar Month View Display the time of an event.
Is there an option in the Calendar view to show the time of each event? I just checked with Google Calendar and the Outlook Calendar and both show the event time when using the month view.
Set a variable from a multiline Field
Hi, I creat a form with a multiline field (Notes) Form 1 Name: bert Notes: visit new customer I'm trying to imported the Notes, selecting the name of the person in a new Form (Form 2). I defined this xpression in the user input of the customer name in the Form 2 Activity_notes = Activities(Form 1)[ID == input.Customer_Name].Activity_Notes; But when i access to the app and select the name the notes are not imported. Some body Can help me.
Duplication \ Creating a new form on user demand
Hi Zoho Team, I need to give the user an option to create a new form (and report), based on a template. After the user enters the number of items in the project, I need Zoho to duplicate a form (currently hidden) the number of times the user entered (5 items = need 5 copies of the template form, with a report for each). The user also enter a name for each item, and I need the new copies of the form to have the name the user entered as "item form - name1" "item form - name2" etc... How can I do this?
Need skilled developer to build simple app
We currently have a database of customers in Zoho CRM. We have several reps that manage these customers. We want to build a simple app to count the visits every time we meet a customer. The sample image shows you what we need. We want our reps to search for the customer and click on the type of meeting (1 click) and nothing else. We don't need notes or any other info. We just want to count the encounter and the date the encounter happened. We need this information stored back in Zoho CRM and I
Report Builder: Section Border lines broken
I really like the Report Builder for generating organized reports. However, I am frustrated that I am having problems with using a border around sections. When displayed in the browser it looks fine with neat lines around each section. But when I go to print or save as PDF the lines are sometimes broken or have an inconsistent thickness in certain places. It seems wherever I have a label on the left with a white background it somehow interferes with the borderline which is supposed to go around it.
Sendmail doesn't work for certain domains?
I have a Sendmail statement at the end of an onClick action of a button on a stateless form. I have found when testing the system that when the email address is a gmail account, the email arrives as expected. But when I send emails to addresses in our own domain (eg. bob@mydomain.com) they disappear - no errors, no spam, not caught in the email filter. They just vanish. Any ideas about potential causes? Settings on our exchange filter that would block these? Thanks, Peter
Restore Backup failed
I am trying to restore a backup of my app, but all i get is: "Restore Failed - Error Occured"
Share App
Hello, I have an app that is shared with my client, he can see the app in his Shared Apps area but when he try to open the app he gets the message: You are not authorised to access this view in Zoho Creator. Go to Home How do I fix it. ThanksRodny :)
Field Permissions
The following link has the feature I want to work with, but the directions don't match my application.... https://www.zoho.com/creator/help/security/fields-and-links-permission.html I can't find any setting about Field Permissions....
Cannot Use Global Search
I am new to Zoho Creator. I have the Enterpise level subscription. I created an application and loaded some data. I taught my time how to use the global search to enter a first name, last name, etc and have it pull up a record. Everybody LOVED it, so I uploaded some data. NOW..the global search does not work. My team is having to use the search by field from within the report, which works but it's clunky. I reviewed the help topic for global search. I've used settings to Show Search Box and clicked
Dynamic VLOOKUP and Summation Calculation
I am trying to do the equivalent of a series of excel VLOOKUPs. I have uploaded a dataset where column A is "Car_Model", column B is "Car_Cost", column C is "Insurance_Cost". I'd like to only use "Car_Model" as an input (via a drop down) and then show Car_Cost, Insurance_Cost and Total_Cost (a sum of the two) as dynamic outputs. By visiting a few similar posts on the topic, I understand that I need to use a "fetch" here but I'm unclear on how to implement it. Thanks a lot! Sam
Making every checklist line a hyperlink
Hi, I'm trying to create a checklist where every line is also a hyperlink to a file in the Google Drive account connected to the Zoho Creative account (each line refer to a different file). Until now, with no success :\ Help? Thanks! Ravid
Update same field for other records based on edit to the field on one record.
I have a form called Orders with 3 fields: Project Number (Single Line), Customer Name (Single Line), Sequence (Number) I need to set and change the order in which we will do each job regularly, hence the number field called Sequence that I sort records by. Example starting data: 100101 Good Customer 1 100105 Other Customer 2 100106 That Customer 3 100110 Excellent Customer 4 100112 Best Customer 5 I'm looking for a deluge code to attach to
reorder subform
hi, do you have a solution to reorder lines in a subform on a specific field ? thanks you
Fetching a Main From record from a Sub Form
I have a form in which users submit information on a Main Form, and include entries regarding completed service projects in a Sub Form. What I'm looking for is a way for each of the Service Project records to "fetch" their Main Form. In the Main Form, the list of Service Project subform entries would be a List of the record IDs of those entries. So, in the Main Form the subform is called "Service", the record ID I want to match back to the Main Form is record_ID. When I try to run a fetch like s
Are alert messages translated automatically
I'm planning my project and would like some additional information about the translations functionality listed here: https://www.zoho.com/creator/help/application/translation.html If an application has multi-language support enabled, do alert messages that the developer creates get translated automatically? Can custom translations be created for alert messages or just field names? Are the contents of fields translated? Thanks, Marcos
Zoho Reports data into Zoho Creator
What is the best, or really any way, of pulling live data from Zoho Reports into Zoho Creator. I'd like to query tables in Reports and pull specific info out into Creator. Thanks
Line break in Multiline text when sending mail
Hi, I have an issue with the line break in the multi line text box when sending mail. 1. The line break does not work, because line breaks is "deleted" and it shows only a long line of text. This is very inconvenient, as the lack of line break renders the text introduced unreadable. I have tried both HTML and PLAIN text messages. Are there work arounds for this? 2. I manage to maintain the line breaks using templates. The problem I have with this is a bug in Mail for iOS, where the message is truncated
How to detect maximum number of executable statements per deluge action
How do I detect if one of my users has reached the maximum number of deluge statements limit so I can have them contact me so I can manually update ranges of records for them? What's the best way to notify the user and log the event? Is there a way to test a function prior to execution to determine the number of deluge statements it will consume? If I call a function that has 2 statements, would that count as 3 statements? This is the case I am trying to solve for: I have an application that groups
Exclude fields from update on edit
Really could with some help if anyone knows the answer to this :) On Form A I have the following bit of code in the "On edit > On Success" which updates Form B when Form A is edited: for each item in input.Products { inv = Product_Inventory [ID == item.Product_Name]; inv.Available_stock = (inv.Available_stock + item.Quantity); } However I have 2 fields that I need to be editable on Form A that do not update Form B when being edited. Does anyone know how I can keep the above code in On
Column Headings on reports
It would be very nice if the column headings on reports appeared on every page and not just the first page. Thanks, John Everling
How to show actual customer data in the report/portal before it's submitted?
Hi, i have got a question about the presentation of customer data. what i do: - report settings, summary - customer viewers - add criteria : Added user equals to Zoho.loginuser This shows the customer their own data after that is beind submitted, but... How can i show the customer data before it's submitted (based on their e-mail adres) something like this : Email_adres equals to Zoho.loginEmail how can i fix this?
Advice Required - Restaurant Booking Application
I have been scratching my head for the last hour or so, and am not making much progress on my latest App, and wondered if anyone in the community had any ideas..... Scenario : Application for assigning guests a table in the Hotel Restaurant. Guests arrive on different days of the week Guests might have a holiday duration of 2,3,4,5,6 or 7 nights There are 200 tables in the restaurant On arrival guests are assigned a table which they use for breakfast & dinner for the duration of their stay I already
How to save a date like a Visa Expiration Date?
I would like to save a date like the format in the Visa Cards. Something Like 04/19 Is there any way to do it?
Mass update Account for selected Contacts
Hi, I have a requirement that on a Contacts view you can select some Contacts and then press a custom button that will open a small window where you can select an Account and that account will be set for all selected Contacts. I was searching how can this be done but yet found no way of doing that. With a custom button for example I can open Zoho creator form but how to pass selected Contacts to that form? Or if I create a custom Zoho creator form to use it instead of Contacts view is there a way
Rookie Question - How to customize Auto ID number and make it shown while entering new entry.
Hi All, Would you please tell me how can I 1 Create an Auto generate ID number - Using the Country, the Year, month, and order VN 1603002 VN > Country relate to list choice field 16 > Year 2016 choose in the date filed 03 > March - from the date field 002 > the 2nd booking in that month 2. Would it be possible to make it shown while entering data or at list shown in the auto text appear after I hit "Submit" button. Thank you sooooo so much in advance :D
Prevent further data entry without "cancelsubmit"
I have a client form with a status field 'approved" or "not approved". In a second form "Repor"t: there is a Lookup field" that returns the value of of the client status. If the status is "not approved "I basically need to terminate data entry and gently boot off the user and get them to fix the client status. I do not really want to use the validate script on submission as it will annoy the user no end to lose the date entered after completing the form. I guess that i could hide all the fields in
Automated testing tools
What automated testing tools are developers using for Zoho Creator applications? I'd like to setup regression testing that simulates user input and can determine if the response from my application is as expected.
Allow user to add "choices" to a drop down list
Hi, Is there a way to include in a form a tool allowing the user to edit (directly from within the form) the choices available in a list (drop menu, check box...) to either add an option or change the options listed? If not, is there a way to add (next to the concerned field) a "button" or hyperlink pointing to a page where the user can edit the values available in the list? The "Allow other choice" option is NOT an option as this only allows the user to add a value not in the list for this one
Next Page