Subscribed, and now I'm locked out!!
I finished my trial, decided to commit, subscribed.... and now I cannot access my database!!! Any suggestions?
HELP SUBFORM ACTIVE
Hi! Someone can help me fill in fields with a subform where the main form fields are lookup´s
Replace function
I have a field called post code I want to do 2 things 1. If the user inputs the post code as DA81HG or DA116DF I want to convert these to DA8 1HG and DA11 6DF 2. I want to be able to convert DA8 1HG to DA8+1HG for google map purposes. Cheers for any help.
zc-footer
How do I edit what is displayed at the bottom of all my creator aps? Live example: Page source: Cheers, John Whitney
Comma-delimited list in Deliuge
Child form has fields for State, City: Example Ohio | Akron Ohio | Toledo Ohio | Youngstown I want parent form to show: State, CityList Ohio | Akron, Toledo, Youngstown Can I script that with deluge and how?
SubForm Limitations
I understand that a sub-form's deluge scripting don't happen when data is posted. I'm finding this problematic, but surely there are work arounds.... 1. Can a script run separately to do the necessary updating (eg, updating fields with related values) 2. Can data in a sub-form be shown in View Only? So that the data is posted by other reports, but I can still see a master form with its related sub-form information? 3. Do you create buttons from the parent form, that open up child forms? It's
Field Setup
I have created a application in sales management.Its a Property Management.So I created a property entry form.I have a apartment name field .My requirement is i entered apartment name, then address filled automatically.
External connection from Tableau
I'm using Tableau software (www.tableausoftware.com) for all my reporting and data analysis. Is there any way I can make an external connection to my Zoho database from this software or is this planned for the future?
Fetch record
Hi guys, I need fetch record that match the criteria of total of request submitted for day are < 100 and alert that which is the first day with less than 100 request submitted. How can I set a complex criteria that collect Day = input.Day < 100 and then return first day available? I try some count function and expression without success. Any suggestion? Thanks Mike dayavalaible = Form [ID != 0] sort by Day range from 1 to 1; dayavalaible1 = dayavalaible.Day; alert("First day avalaible"
Control column width of fields in sub-form
I know how to control the column width for columns in a list I know how to hide columns in a subform How do I control the width of columns in a subform?
Date Expression help - Next_Day(date,weekday)
For any given date, I need to know the next Sunday date - for example, in Oracle the formula would be: NEXT_DAY('18-JUN-2014', 'Sunday') would yield June 22 2014 I could create a lookup table with every date, and the corresponding Sunday, but I prefer to create a formula. Any suggestions?
Emailed data to Form, Captured Attached Images, Need to Update them to Image Field
I have successfully emailed data to my form using it's unique email address. This is a great feature. I have also captured the images attached to the file using the ZC_file field name. What I need to do now is update another forms image field with the above captured image files. I've tried using the update deluge script but the image field is not updated. See below entx = Entries[Entry == input.Entry && TrialID_Entries == input.TrialID_Entries]; entx.Image_1=input.ZC_File0; entx.Image_2=input.ZC_File1;
Phone Number
Hi, I have created a number field for phone number my no format is :943848343812 but in zoho creater phone show like this :9.940057402E9 How to change this format.
creator formula for lookup value
I am using zoho creator and doing some really cool things with the formulas, one thing i am stuck on in creating a field with a number from data I have added, for example, my input field value would be something like "54" - 1372mm" but i would like a filed to look at this and automatically enter "1.372" also it would need to also be able to convert "30" - 762mm" to give a response of "0.762" ... many thanks for looking at my post :)
Update value in subform before submit
Hi I want to put numeric values in a sub form and total up the values in a separate field before pressing submit. For example i have 3 fields called Size 1, Size 2 and Size 3. a fourth field called Total of size. When i use this as a sub form i want the total to get updated as i enter a number in size 1 and than that total to get updated when i enter another number is size 2 and so on. Thanks
Hide/Show based on values from Checkbox field
Options is a checkbox field, with Option1, Option2, Option3. Based on the selections, I want to show or hide the subform fields (named Option1, Option2, Option3) This is what I tried but doesn't work: if (input.Options contains "Option1") { show Option1; } else { hide Option1; }
@Martryl: Autofill Subform sample
thank you for sharing your Autofill subform sample. I've learned from it and can reproduce it for my application - however, I have a question. If the user selects Vegetables, the sub-form is loaded with the single value of bean. If the user changes the selection to Fruit, the child form RETAINS the value of the Vegetable, and ALSO adds the fruits. That might be nifty in some instances, but I would like the child values to go back to blank if the user changes from Vegetable to Fruit Can you (or anyone
toLowerCase Problems
My application includes several forms which each ask for the users name and email address. The email address is used as the identifier to cross reference records on all forms for fetching data and lookup fields. Everything was working fine until I realized that is a user inputted their email address with different capitalization, the scripts would not be able to match up their records because strings are case sensitive. I looked at these hep articles <string>.toLowerCase() and Built-in-functions
Not a valid currency error
My client reports: I continue to experience errors when attempting to import currency from my excel files. The issue began about 4 weeks ago. Previously, for the past year, I never had an issue. I have not change anything in the excel files we import from. Seems Zoho has changed something. I am having to edit 9 excel files each week so the Zoho application will accept the import. Then I have to change each excel file back to its original format so I can email to customers. Wow, what a pain! He
Column does not show as option for report?
I have attached screenshots for reference. The column "Agency-Vendor Id" is not appearing in the pivot table I am creating, while the "Status Category" column shows up and works great. Does anyone have any insight to why this is occurring? Thanks.
Zoho Creator calendar popup
When using a date/time field in Creator, the program puts a calendar popup for the user to choose the date and time. Unfortunately, in Creator, the popup is kind of awful. It looks ugly and it is horrible at selecting the time because you can't scroll through the time. You have to click. I'm sure you know what I mean. (I'm sorry if that was a confusing description.) The date/time popup in Zoho CRM, on the other hand, is much more user friendly and looks a little nicer. Is there anyway to use
email data
Hi, I have a form which collects user inputted data from my website and sends an email notification with specified data. Is it possible to send this data by email as a spreadsheet attachment? Thanks
Problem Calling a Function
Hello There, I'm having a problem when calling a function via "custom Calling". I have a grid view where I show the "departments" of a "Company" and from there I want to call a function "GoEmployee" where I have to pass through 2 parameters, (CompanyID and DepartmentID) but I can not pick the CompanyID because of the field type that was assigned to that field at the moment of the creation. I have attached an image that illustrate what my problem is. Any suggestion will be very appreciated.
users cannot access uploaded file from view
I've created a view which includes the column for 'file upload' and everything works fine for me as the developer. The users can see the blue link, but when they click on it to download, they are being required to login. I've opened the entire application as public I've confirmed both the view and the form are published. Is there something I'm missing that will allow 'joe public' not access the uploaded files when I embed the view into a webpage?
Can I add an HTML or Deluge Header or Footer to a List Report?
I want to add a Header and footer to my report. A short introduction to the data present in the report and then a footer explaining action that needs to be taken on the data. I would like to be able to write the header and footer in HTML or in Deluge script. I would like to set a custom schedule to email this report with header and footer on a repeated basis. I have already created an HTML page with the report embedded in the center that looks exactly the way I want it, but I cannot create a custom
Options in Embedded Report (Export, Print)
Hi all, I am embedding a report of type list in an HTML page and I would like to have the option to export data (same feature than the one in the standard report not embedded). But I can't find how to display it. Also, I would like to remove the Print option next to each record but again, I can't find how to disable it. Any idea ? Many thanks! Guillaume
Tutorial: How to count booleans
Ok, I have rows of data, and each row has multiple decision booleans, which are progress criteria for a job completion. My goal is to total the "true" booleans, and use this total to represent "amount done". I struggled for three hours trying to figure out the correct syntax for this, searched the forum, nothing. I hit upon the solution quite by accident. So here is how you do it: Say my project names are in string column "Project Names", and I have columns for "step 1", "step 2", and "step 3",
Downgrading ZohoCreator
My internal project is on hold for a while. Whether we goahead at this stage is unknown so in the mean time i would like to downgrade my professional ZohoCreator edition to the free account. My question is if we decide to carry on, and I upgrade again will my database still be there from before? and if not, can i restore a backup of one from previously?
Customer portal vs. Share in Creator
I've just updated my account to Enterprise, believing that the customer portal gives the flexibility to manage the users. I have an app where I have more and more users, so far I had to create an email address for the user in Zoho Mail, then creat the same user in Creator, and then do the programming (scripting) to get the login name from them. (I have some scripts where I need the individual user, since some data based on them) The Customer portal is something else, but how can I make this long
Customer Portal
I am trying add the customer portal, but when I clicked to proceed (add on customer portal) the customer portal isn't showing for me. What I have to do?
Show links from subform in main form's report via script
Hello, I have a form by which I upload files. Each record of the parent form needs to be associated with 1 or more uploaded files or URL links. The only way I know to associate a variable number of uploaded files or linked sites is to use a sub form. This part is OK. However: I want the end user to be able to click on a link to download the stored file or access a web-URL directly from the parent form's report without having to open a separate window corresponding to each of the sub-form entries.
Zoho Creator
Hi, I am trying to create a new app using zoho creator. I am trying to create an app called "compressors", I want to mimic the "products" app that is already available but with minor adjustments. Do you have any ideas on doing this? Thanks
Is it possible to have a conditional Payment form?
Hi there, my client has a requirement to allow direct deposit as well as PayPal payment. Is it possible to make the payment form conditional so that if the user chooses "Direct Deposit", they won't be directed through the PayPal gateway? cheers, Jeremy
Page
What is the use of Create page? I Saw that user guide but i dnt understand pls explain me
Search reports in summary view?
Is there a way to search in summary view? I've seen in other posts that this was not supported. Our database users are used to seeing company records in a summary view and searching within that view. Is there a workaround?
Only show fields with data
When creating a summary report, I would like only the fields with data do be shown. So for example, if a given record doesn't contain data in the STATE field, I would like that field to be hidden on the generated report.
get items in a Dropdown as a list
I have a static Dropdown with (say) 5 options: A, B, C, D and E. is there a way to call these options as a list? alert Dropdown ; will only return the selected item ("-Select-"), not all the options. I'd expect that to be the result for (which it also is) alert input.Dropdown; this doesn't work either: alert Picklist.toList(); any suggestions? (I'm hoping to find a way to make a subselection for a list without having to lookups all the time, because this lookup is significantly
Does anyone know how to import Cognos reports into Zoho creator?
I'm new here and can't even get started. My excel files from Cognos don't integrate well into the Zoho. Is there a developer out there that would like to work on a project that could help change the performance management process for a category in the CPG industry? Would love to collaborate on this project to get it moving along.
Report Only see my records
Hello, I have a report and in this report I have a field called "Assigned To" which has an email address of the of the person that equipment is assigned to. When anyone accesses this report I want them to only see records where "Assigned To" equals the email address of the person logged into Zoho Creator. How can I do this?
View/Report help
Form1 has a look-up to a Team Team is connected to Teammembers How do I get a report that connects Form1 with all of the Teammembers? ie, if a record in Form1 is connected to TeamA, and TeamA has 5 teammembers, my report (unfiltered) would have 5 rows (ie, 1 row for each teammember) in MS-SQL, the view would be: select T1.* ,TM.* from Form1 as T1 inner join Team as T2 on T1.teamid = T2.teamid inner join Teammembers as TM on TM.teamID = T2.teamid
Next Page