How to send an email when a public user submits a form?
My app allows a public user to create a profile including their email address. How can I get the app to send a welcome email to that user? Sendmail seems to be prevented by the restrictions at https://help.creator.zoho.com/Send-mail.html. Thanks.
Adding form by mail no longer works on our service?
Hello, Adding form by mail no longer works on our service? Eric
How do i take a value from an ending value from a field and use it as a starting value the next time i open a record?
Yes, i want the ending volume of the previous record to be the beginning volume of the next record. i have also provided edit access. in our winery every action starts with a beginning volume (bvolume) and ends with an ending volume (evolume). by way of example: Chardonnay beginning volume = 1000 gallons chardonnay filtered Chardonnay ending volume = 980 gallons The next time i open this field, i would like the beginning volume to show the ending volume (980 gallons) from the last action. Can
URL field does not update on deluge script
Hi, I'm trying to use the URL field in a form (in order to access an uploaded file) as stated in the kbase, I'm trying to put On Add & On Edit: input.link = ("<a href = http://www.amazon.co.uk/exec/obidos/ASIN/44764967 target=_blank>Link to Amazon</a>"); But the field stays empty for the user. On updating or saving, the field is still empty (on view). Am I missing something or is it a problem in the system? Thank you, Tal
Automatically populate a field based on previous field's data?
Hi, I am wondering if it's possible to automatically populate a field based on the previous field's data? We are looking at creating a Library Check-in/out system for the students that come in and out of the library at our school. So for example, we would scan the student's id card and the id numbers would go into the Student ID field. Then we would like the student's name to then appear in the Student's Name field - the name would be based on what the id is. I'm assuming we would have to import
new Bug: Validate script on Update does not Run!
In "On Edit" --> "Validate" i have the following test script: alert "nice"; From View I edit a record (same for all forms) press the update button, and the user does not get any message, Please help
How to fix report shows different horizontal alignment for fields?
My report shows different horizontal alignment for different count values: Anyone know why, and how to fix? Thanks.
My forms not appearing in mobile.zoho.com
Hi, Not all of my forms are not appearing in mobile.zoho.com. Forms and views from one application appear correctly, but they don't from another. I built the other application yesterday, I built the new one today. Do I have to do something special to make them appear on mobile.zoho.com? Thanks!
Can I expand/collapse a field in an HTML view?
It seems that javascript isn't permitted. With javascript, I could make an HTML View which allowed the user to hide or show a large field by clicking on a button. Is there another way to accomplish this?
Function not saving even though the code was not changed
When i try to save one of my functions ('ViewMatchingAssets') without having touched the code, it throws an error (a variable is supposedly not declared). The apps name is 'BMPM'. I have granted edit access to Zoho. Thanks for your help. Regards, Filip
html viewでのzoho logoの削除方法
zoho createrで伝票作成のために、html viewを使っています。 html viewの表示をそのままプリントして伝票として利用したいと考えているのですが、右上のpowered by zoho creater の表示が書類に載ってしまうのを消せないかと思っています。 このzohoのロゴを消す方法はないでしょうか？ あるいは、別の方法で、伝票等の作成をしたほうがよいでしょうか？
Have field populate data automatically from previous field data?
Hi, I am wondering if a field can populate data automatically based on what was entered in a previous field? We are looking at creating a Library Check-In/Out system at our school for the students that come in and out of the library. For example, we want to scan the student's ID card which their ID number would get put into the Student ID field and then I am wanting the Student's Name field to then automatically get populated with their name. So when I scan in their ID and jump to another field
Serious issue with Rich Text Fields on embedded views
ZC Team: I've found a serious problem related to the rich text fields, which may lead to data loss in some situations (actually, I've lost some data from a rich text field in a record from an application). Look at the view here (by the way... I saw that the permalink now contains a number instead of the Zoho username - was this an intended change?) It has an embedded (using div tag) form and an embedded view (whcih is a view related to the form above it). Try to edit a record in view. You'll see
Criteria Restriction is not working in Views
It appears that the criteria restriction option is not working for views. I have tried this across several applications and all give me the same error message: "Adding criteria failed. Please try after some time or refresh the page and try again." I have refreshed, closed my browser, and even tried using another browser, but nothing is working. Without this, I am unable to add criteria through the script builder or free flow scripting modes.
URGENT- Creating multiple records unsolicited
We encounter a major problem on Zoho Creator. Whenever you add a record by mail,data registers 10 or 15 times in the database. That created duplicates and much more.Can you see where is the problem?
Hide form in database homepage
Hello all, New user/developer here. Working with Creator. I created a few lookup tables to populate lookup fields in a main form, but I don't want those lookup forms or table view to show in the 'Home' menu on the left side of the database home page. Is there any way to hide those individually? Thanks!
Creating a database contractors
My question is: I'm creating a database for contractors to advertise to there services on a website. The contractor input there information ( kind of like a small yellow pages) How do I make it so when a contractor enter our website, they click on tab, enter there info, and then it displayed on our website under a selected State or profession. ie. roofer in Florida, painter in Ohio
Can I capture a signature in a form on a mobile device?
Can I capture a signature on a form when using a Creator app on a iPhone? Maybe use a Rich Text Field? Suggestions?
Conditional Formula
Hi, This is a great application. I love it! Is it possible to make Formula values conditional on the value of other fields? eg NewField ( type = formula if ($OldField == "Old") { value = "New" } else { value = "Old" } ) Thanks, Lee.
Send Mail from View
Is it possible to Send Mail automatically when a View is Displayed. Currently it seems that when a Function is defined and called using Custom Actions in View, it is necessary to select action from header of record to send mail Thanks
Parsing JSON export feed from application
Hello, I am trying to parse a JSON feed from my Creator application so that I can use the data to make a JavaScript/HTML widget. It would appear that HTTP GET requests to the feed url return a content type header as "Content-Type: text;charset=UTF-8" and not "Content-Type: application/json;charset=UTF-8", so I am not able to parse it correctly (e.g. my JSON object is null). The feed URL I get from going to the production side of the application, going to the form list view for the data I'd like,
Allow non-developer user to edit records
At the moment we are using the free account but plan to upgrade to a paid account. If the following is available in the paid account than this is irrelevant. Is it possible in Creator to give the user role rights to edit existing data? I have figured out that the developer role can edit existing data. I want to configure a role that can edit existing data from a view but cannot edit the application. Is this possible? If not, is this a feature that is being considered?
Fetch
How can i fetch records from other applications? And what other applications can i fetch from?
Fields Not Showing Up in Edit View
Hi all, After making some tweaks to a form, only the first seven (out of 40 or so) fields are showing up in edit view. This is a problem, because I need to edit other fields! They are still showing up on the form itself. Reloading the page, logging out and logging in, etc. haven't fixed this. Any ideas?
How do I link forms
I am creating an application and cannot figure out how to have it link my forms. I have a main form with 3 checkboxes. If one is chosen I need the form "Tables" to come up. If either of the other two questions are chosen I need the form "other" to come up. How can I do this?
Undefined, Unset, Empty, False, etc...
How do you test if a variable is Undefined, Unset, Empty, False, etc...? Do you compare to null, "", "-Select-", length() == 0? All of the above? (I sure hope not!!!) Which comparison do you use for a string field type of Single Line/Multi Line/Single Select/Multi Select? I gotta say, checking against "-Select-" is the single stupidest implementation in the Deluge scripting language. Worse, it's not always a string. When returning an empty/unselected dropdown value back from a function, you
Link to image in new window
After a user chooses a file to upload on a form and submits the form I wanted to create a url that would open a new window with that image in it. Is this possible to do?
set null variable
how can i set variable to null in a script? for string i use "", but what about float fields? bruha.zoho
PRINT /EXPORT PROBLEM
Print|Export stopped working on 02/16/2011. I can see my view, but when I select More Actions - > Print or Export, I cannot get connected to the server and system hangs...
Problems with user designations and script actions
I'm running into errors where i get proper results while creating and debugging forms with script while logged into my admin account, but testing the same pages with regular users don't work at all. any help would be appreciated, because if i can't count on the forms and script to work properly i will need to seek an alternative solution.
Chrome and Stateless Form Buttons
The submit buttons on stateless forms do not work in Chrome. John M. Whitney
Problem with Usage Limit
Hi, I'm trying to execute a function, but it keeps failing: Execution Failed Error details: Error occured while executing the script. The execution is stopped since the number of deluge statements that can be executed in an action has exceeded the maximum limit. You can view your usage limits here. But when I check the suggested link to see my usage limit, it says I have not exceeded any limits. I have shared my app "GolfHandicapCalculator" with Support. The function I am trying to run is called
Serious problem with Views Criteria
This statemetn, entered via "advanced" criteria of a view, used to be accepted and is indeed used within two of my views (zoho.loginuser == CenterCode.UserName && SendTo == "Participant") Now I get the message Adding Criteria failed. Please try after some time or refresh the page and try again. and thi happens on new views I am defining BUT also on the ones where it used to work if I try to save them again !!! Please help as soon as possible. Thanks.
Import Excel Spreadsheet
How to import an Excel spreadsheet to a form or view, or how best to display it in anapplication? I need something like google docs e What better way to show an excel spreadsheet in Zoho Creator? Thanks
inactivated account
I have asked a few months ago to reactivate my 2nd account : VIF. Can you reactivate it and tell me what was wrong with it (to solve the pb if relevant)
Permissions
Is there a way where i set permissions where my users can only see what they add in but me as a admin can see what they added in?
Field does not update for a certain record
I have a field (Overlapping_Search_Profiles) on a form (frmSearch_Profile) which for one record does not update when I do this: colSP.Overlapping_Search_Profiles = ""; and the record is part of the collection. I already checked if the record actually is included in the collection. Zoho has Edit Access. To reproduce do this: 1. In my app (bmpm) go to the section 'Admin' 2. Open the view 'Export View: Profiles' 3. Search for the records with 'aer' in the 'Player' column 4. Open one of the two records
Formula field, number of digits
I have defined a formula field in a form, calculated from other fields. How can I define the number of digits displayed on a VIEW? Even if the formula field result has 10 digits, can I define the VIEW to display only 2 digits? Thanks a lot.
Saving function without having made a change to it returns error
The following function was previously saved in Creator: string otherrecordmanipulations.CountEntityProfiles(string EName, string PName) { countNumber = count(frmSearch_Profile[((((Player_Entity.contains(input.EName) && Player.contains(input.PName)) && !Player.contains(input.PName + ":")) && Status == "Active") && Player_Status != "Passive")]); if (countNumber == 0) { return "none"; } else { return (countNumber).toString(); } } If I click 'Save Script'
Code comment not saved
In one of my scripts (on edit / on success) of the form frmSearch_Profile. I can not include a comment line ("// bla bla") above the line 'thisapp.TestFunc4(IDStr);'. Zoho Creator deletes it... Zoho has Edit Access. Regards, Filip
Next Page