How to best create an On Add Validate script to include only 1 record per day?
I took a stab at this but couldnt seem to figure it out. I have remote users (on smart phones) entering data into the forms. It seems the delay after hitting submit is quite long at times causing the user to hit it again. This enters in duplicate forms. With what I am doing I could limit them to one form per a given criteria. Here is an example of the fields: Home Address - Dropdown (based on another list of 60 properties) Notes - Simple notes field Time/Date stamp How would
Email a copy of an uploaded file to admin user?
Is it possible to automatically email a copy of an uploaded file on success? I know that it is possible to email a link but would prefer the actual file.
Display image from dropbox
Is it possible to display an image that is stored in dropbox? I'm using an image field an putting the dropbox url of the image in the link field. I can not get the image to show in the view. Images that I uploaded from my local computer display correctly.
Need numerical data from one form, count from another form, to provide a "Total"
I have a form "Events" used for training and outreach scheduling. There is a field "Total Scheduled Event Hours". I have a second form "Registered Attendees" with a Decision Field "Attended". (This field was added to swiftly identify the number of actual attendees from the list of registered attendees.) I have a third form "Trainings" with a Lookup Field "Event_Title" that retrieves event title, total scheduled event hours, training topics, and training method (Training_Title, Total_Scheduled_Event_Hours,
Deluge: How to return the first 3 letters of a string and capitalize them..
Thanks
Need help with "The number of deluge statement execution limit exceeded the maximum limit."
I am getting the following error, which is stopping my schedules export: Execute Script Help Execution Failed Error details: Error Executing the workflow Owners Operational Reminder script(Custom Schedule). The number of deluge statement execution limit exceeded the maximum limit.
How to transfer text from one form to another one
I know that with the usage of lookup field I can create relationships between the forms. We can create checkbox, radiobuttons etc. My question is: If I have a form with two fields ROOM(single line) and DESCRIPTION(single line) with the following data: ROOM DESCRIPTION single This is an amazing room double I love this room then I want to display them in a new form dynamically: with the usage of a lookup (dropdown), I can choose the type of the room but my problem is than I dont
How do I turn off the "add new" in subform?
I want to get rid of ability to add new, and the ability to delete
Issue with dynamic picklist
I'm having trouble getting a dynamic picklist to work properly . Here are the specs for the 3 forms: Form 1: Supervisor Fields: Super_Name, Super_Location Form 2: AC Fields: AC_FirstName, AC_LastName, AC_ID (unique), AC_Supervisor (dynamically from form Supervisor.Super_Name) Form 3: Input Fields: PreCall_Supervisor (dynamic dropdown picked from Supervisor.Super_Name, working ok), PreCall_AC (dynamic dropdown to show only AC_FirstName, AC_LastName based on the selection in the previous dropdown,
Fetch data and data format in email notification
Two questions: 1. I need help figuring out how to fetch data. I have watched videos, read articles....all to no avail. It worked on the old app builder but I can't make it work on the new builder. Here is my situation: Form 1 = Contacts Fields: Name Email Address Form 2 = Projects Fields: Project Manager - Lookup and select from Contacts form, Name field Email - Fetch data based on Project Manager selection ****How do I do this?**** 2. The email notification I receive upon submission of a
Record summary - related form, different fields
Hi, I'm trying to create a record summary for a list view based on a form which have multiple fields related to the same form containing employees. But when ever I add the "Name" field from the related form identical values are returned, even though different employees IS selected i the different fields, and is shown correctly in the list view. A simplified example of the form: "Created by" -> Employees.Name (Value = "User_A") "Assigned to" -> Employees.Name (Value = User_B") When I just add one
Chrome extension for interface localization - what laguages to add
Hello all! I like Zoho Creator)) But it still only on English For my users very important to have Russian interface elements (Buttons: Add, Edit, Delete, Column headers menus: Sort, Group, Search, Additional menus and so on) becase some users don't know English well (( and we need to waste time to explain basical functions of working with interface. So we've made Chrome Extension, which translate these interface elements: It's looks like: you install once this extension and then all pages of Zoho
How to De-Activate Two Way Authoraization??
I have activated Two Way Activation. Now, as it sends codes and asks for the same everytime, I want to de-activate it. How can I???
Date-time "eomonth" ignores the year component.
Executing this on 06th Dec 2013, both the alerts print "31-Dec-2013" while the expected result in the second print at line:5 is "31-Dec-2008". dateParam = "13-Dec-2013".toDate(); alert eomonth(dateParam,0); dateParam = "13-Dec-2008".toDate(); alert eomonth(dateParam,0); For now, I'm using the following work-around with expected results: dateParam = toStartOfMonth("13-Dec-2013".toDate()); alert dateParam.addMonth(1).subDay(1); -Varun
How to Check if an upload field is empty?
In scheduling an action on a form, in this case to send a copy of an uploaded file to a user, how can check if the upload field is empty?
Suppress duplicate values in picklist: can it be done?
I have a Lookup field that shows a person's name, drawn from another form. The person can have more than one record in the other form, so the picklist in my lookup field shows the same name more than once. Is there any way to suppress this? I see the same question in this forum five years ago, with the answer "no". Just wondering if anything has changed.
Put image on application
Hi I want to put an image on the start page of my application.... How can I do that?
Not Null question
what am i doing wrong here? I get an error on the if statement. Help if(input.Lineman_6 != null) insert into Employee_Time [ Added_User = zoho.loginuser Date_Field = input.Date_Field Name = input.Lineman_6 Overtime_Hours = input.Overtime_Hours Regular_Hours = input.Regular_Hours ]
Zoho very slow??
Is anyone else having problems with Zoho Creator going very slow? All forms & views, submitting, etc. Everything is slow to the point that it hinders our business greatly. It might speed up for a little while, but overall has been very slow for the last week. Anyone else? Support is not being very helpful. I am already researching alternatives to Zoho but the transition would take very long.
What happen to the Number function reference link?
Folks, The Deluge Script Reference page for Number Function under the Built-In function page is missing. It only has Math function listed now. I am talking about the page that shows functions such as toLong(), etc. That page is missing in the Reference -> Built-in Function section. It uses to call "Number Functions". So can the Zoho team bring it back please? Thanks.
how to add search button in the view header?
how to add search button in the view header?
Lookup Filter in subform
Hi, I am working on a fairly basic form for placing orders. There is a lookup field from which the client can be selected, and a subform containing order items. As the products which can be ordered are unique to each client, what I am trying to do is to have the "Product" lookup fields within the subform only display products from the selected client. To achieve these I have added a client lookup field in the subform, and when the client is selected manually the product filter works as expected,
Fetch and update
Would like to select data in a look up field and have it populate data in another field in the same form. Example Select an individuals name via look up in form2 and have it fetch the data from pay rate in form1 and populate pay rate in form2.
Subscription problems!!
Hi, I've been subscribed to the Professional Edition for over a year now, never with any problems. But today as I wanted to create another Application, I get an error message which reads: "You have reached the limit of 10 apps in your free edition, please upgrade." Please fix this. Carsten Eckelmann Director, TripleAcs Expert Cloud Solutions http://tripleacs.com
Adding form data via e-mail in user-defined format
I am reading this documentation, https://www.zoho.com/creator/help/forms/email-data.html and I want to add records via e-mail. "Adding form data via e-mail in user-defined format" works fine as described, but is there any way to add more values from the email? Subject, Content, and Attachment are no enough. In our case, I want to store Data/Time, From and To address. It should be possible, but the documentation does not explain further. Any idea? My goal is to archive all incoming messages in one
Email data in user-defined format.
I want unidentified users to be able to email stuff to my database in user-defined format - and it is working fine, to a point. I can extract the subject line and body text using ZC_Subject and ZC_Content. But I don't understand how I can find out who sent me the data. I hoped I might be able to use ZC_From, but it didn't collect anything. Can this be done please?
Continue on next line: what is the symbol?
If a line of my code is very long (such as in a lengthy alert), is there a character I can use to break the command among two or more lines? (Note: I don't mean newline in the alert. That is \n.)
Two column layout
Hi All, I would like to have two dropdown lists on the same line, ie hours and minutes. I have never tried the two column layout before but if I select this option and add a field, the system places it right at the top of the form in the second column and not next to the field required. What am I not understanding here please? Many thanks
target="_blank" issue
Hi Folks, There appears to be a problem in Add Notes. To allow a user to get the geographical coordinates of a location, in my application I have a Note field that contains a Google Maps image and the following code: <a href="https://maps.google.co.nz/?ll=-41.343825,174.089355&spn=14.262413,33.815918&t=m&z=6" target="_blank"><img src="http://www.precisionhelicopters.com/images/site/googlemaps1.png"></a> Until recently, a click on the image nicely opened Google Maps in another browser tab, but now
Unable to Customize Embedded Forms
I have a set of forms which are colour coded for specific teams to complete. I have therefore been trying to format the Header & Footer BG colour setting. I have tried this several times with different forms, but the setting is not saving on the form. When I got back into the form, the settings have reset back to defaults. I cannot see any way of saving these changes.
does zoho creator compatible with visual basic?
because now i'm build a system that need to connect with online database...hope anyone can answer me :) Thank you
Clearing Picklist Record On Load
I would like to clear a static picklist record on load. I want the record to be lose whatever it had before and have no selections. This seems simple, but I have not come across a solution that works thus far.
Check box automatic populating issue
Hello I have a check box in the first and second view of my database. With existing records if I uncheck the box in the first view it does not reflect in the second view. Please can you advise what deluge script I should use? I’ve used a “ input.Commercial = main.Commercial; ” script which works with new records, but if I uncheck the box in the new record in the first view it still does not reflect in the second view. This is also the same with date fields. Thank you very much.
Issues today
Is anyone else having issues with creator today? I have functions that were working this morning, that no longer work. I am having issues with reports pulling up and running after I have created them, and shared users can't pull up new reports. I have one user that can't access any pivot table reports, lists are okay (this is about two weeks old at this point).
Two small animated semi-circular arrows appear after updating a field by script. ??
If I check user input (On User input), format it, and then write the formatted data back to the same field, two small animated semi-circular arrows appear to the right of the field and the field contents persist into the next record. I can't find any reference to this in the documentation. Can anyone help/explain?
URL view criteria involving lookup fields
I have a view that contains a lookup. The lookup refers to an ID in another table(form). I'm trying to open the view with criteria which only displays records where the lookup has a certain value (an ID): E.g. openUrl("...#View:MyView?MyLookupField=1234567890); The functionality based url criteria seem to work fine for non-lookup fields. Can anyone confirm if this works at all with lookup fields? If so, what is the trick to work. Thank you
How to delete applications?
I've create two dummy apps in my account for evaluation purposes. Now I've got paid subscription and I'd like to delete those 2 apps and create a fresh customer facing app from scratch. How do I delete the exiting apps in my account? Thanks, Vijaya
Indentation
There has been some discussion in this forum about the editor/compiler and indentation. Some people don't like automatic indentation. My suggestion is this: whatever automatic or non-automatic indentation is provided, please at least leave my indentation alone! Yesterday I spent something over an hour going through a long script adding comments and indenting sections of it to make it more readable, just like any good code does. I saved it, but then when I came back to it all my careful indentation
Yet another question about dynamic lookups
I have two tables/forms: Franchises and MasterFranchises. Each has a field named Franchise_Name. The forms are identical except that the Franchise form also has a field for MasterFranchise. All franchises are "owned" by a master franchise. In some other forms, I have a Franchise field that looks up franchises in the Franchises table. So far so good. But in some forms, I would like to have a Franchise field whose picklist is a combination of both franchises and master franchises. Is there
Account address to post in contacts
Can you develop a quick and easy way for Account address info to copy or be posted to contacts, it is time consuming to have to enter that info more than once?
Next Page