multi line text box help
Could you please help with this one. On my database I have a feature that sends a SMS message to a client. It sends the message I type into the multi line text box. The problem that I have is that I am limited to 495 characters. Is there a way of limiting the text box to 495 characters if not is there a way of having a counter that counts down every time I enter a letter. Thanks
Display Details from parent form 2 levels above in data hierarchy
Hi all, I;m new to Zoho Creator and am working through my first application - I love it so far. My question is as follows : I have a 3 level data structure : Customer (standard customer information) Utility Meter - Multiple meters per customer Meter Readings - Multiple readings per Meter I have created the form hierarchy and all works well. I would like to have a Lookup on the Meter Readings form that shows the Customer Name from Customer Table. I know there is no direct link - it's through the
Batch add users how?
Hi Think use professional express plan for one app. There is about 500 users who will use this app. How can I add all 500 users in one step? Their accounts email & creator's password are in xls/csv file Other side How can I mass add users to zoho creator cloud with login&password from xls/csv file? (so that after such step I can share my app with added users)
Record Summary View: left-justify data in linked tables
Hello, How do you set data to be left-justified in the columns of a linked table in a Record Summary view? I set both the label and value formats to be left-aligned, but it still comes out centered (see attached images of edit and view pages). Additionally, is there a way to change the column widths, or is that only set automatically? Thanks for your advice. Cheers, Elizabeth
Real time search filtering available?
Is real time search filtering available in zoho creator? i.e. where the results narrow as you type in the search field. See link for video demonstration: http://youtu.be/wfNIK-nhySc
Sales Rep Call Cycle Template
Is there a template that can be used by sales reps that would allow them to populate a few key data points that could be captured and roll up into a database / report. Key fields required being - Store location - XXX Manager name - XXX Store ranking - A / B / C Date - DDMMYY Inventory level - Nil / L / M / H Display standard - L / M / H Staff knowledge - L / M / H This data would then be displayed as a dashboard which would show the rep coverage of stores in their territory each month, benchmarking
Pass Record ID and Variable to a From via URL
I am trying to pass a record to a form and also a variable from a URL Link in another table field. I can't get this to work. Has anyone done this successfully or is this even possible? https://creator.zoho.com/tamyett/saleamp-services/#Form:Infographics_New_Form?recLinkID=1593428000001105925&Step_ID=57&viewLinkName=New_Infographics_Form_Report2
Sum of values for elements from multiselect list
Hello, I have a form where you can select which parts were purchased for a service order. The parts are selected from a 'parts' form which includes fields for 'Part Name' and 'Part Cost.' The user can select multiple parts in the multiselect picklist. I would like to display the total parts cost based on the selected parts. How would I go about doing this? As an example, in form PartsList I may have Part_Name Part_Cost Part1 $10 Part2 $20 Part3 $30 If in field Service_Report.Parts_Purchased,
Bulk edit doesn't run script
Hi Zoho team, I'm trying to have the age of employees get updated once in a while w/out having to update them one by one. For some unexplained reason, when i use bulk edit to update these records, script On Edit doesn't run. Of course, i've checked that my code is working for single record updates - no problem there. is there a workaround for this issue? is the Zoho team working on fixing this bug? thanks, Anat
Embed Audio in URL Field -
I am trying to play a audio file in a zoho view -This works If I do it manually this is the final URL I need in the URL field data:text/html,<audio src="http://mysite.com/admin/recordings.php?recording_id=127" controls> I am using a CURL to add data to creator myURL = ("http://mysite.com/admin/recordings.php?recording_id=") + input.recID2; // I use this to pass recording ID in input.link = myURL; // If I post this into a single box it adds the correct URL myURL2
Use <%=formdata%> on delete
The variable <%=formdata%> can be used in the On Edit->On Success section. It shows all the information on the form. It would be very helpful to use this On Delete. That will make it easy to email all the details of the record when it is deleted. This provides protection in case the wrong record was deleted.
Hiding Tabs for Certain Users
Is there a way to hide tabs based on the logged in user? In my application there are three tabs. I want to have the "request" user to see only the first tab. While the "manage" user sees all three tabs. Possible?
What are the best programming practices to improve performance?
Hello, I find that Zoho is a bit slow when opening a stateless form for editing and I'm wondering if there are some best programing practices to enhance performance. For example I've realised that: 1) Loading data for a dropdown box that depends on other dropdown box that has to be also loaded deteriorate loading performance. 2) If the menu has many views or forms also deteriorate perfomance as the many has to be loaded also when opening the stateless form. But, I would like to know if
filling a URL Field with a null address
Hi All I am a newbie both to databases and this particular method of creating them. I have made a form with the main primary field being the identifying name of an item. What I would like is that the name is clickable to an associated URL path, if there is no link I would still like to see the identifying name. I have used the URL field but it doesn't like a blank URL field and if I use just http:// it brings up a blank page (not very elegant). The important part of the URL field for me is the link
Dependency Fields
How do I get fields to be dependant. Eg: Question: Yes - No (so this is a radio field) IF Yes, I want a few fields to become visible underneath it or even a SUB-FORM and required. If NO then nothing. Thank you in advance.
Lookup
Hi everyone I'm hoping that someone may be able to help us with this question. We currently have a list of customers and a list of service codes. In a form we choose a customer name and then choose a service code for that customer. This may look like: Name: John Smith Service Code: 55P662 We have another form that uses the name, but different pieces of information. We want to be able to select the name of customer (John Smith) then it automatically show the service code entered in the other form.
Sorting CRM query results
Is there an easy to sort the results from a CRM query? Thanks David
Multiday Event Form, calendar view
I was wondering if anyone has ever achieved a multiday event form to view in a calendar view. EG: have a start date/time and End date/time in form. Then the all days of event are shown in a calendar view. Thanks
Best practice when purging records?
I will need to purge records from my 3 hosted databases to keep below the 100K usage limit. Are there any tips to making this go smoothly? For example, can the database be live (i.e. available for users to input new records) while simultaneously deleting records? If not, how do I take a data base "off line" temporarily? Assuming I want to delete 10000 records from each data base, approximately how long would that take? Should I work on one data base at a time, or can I do a batch delete on each at
auto populate syntax question
my apologies if this has already been explained. I have two forms and would like to auto populate data from one form to the other but can't figure it out. What I am trying to achieve is have an office address information (input.Street, input.City, input.State) from "FORM A" auto-populate onto FORM B after the Office Location (input.office) is chosen from a lookup (drop down menu). I have gotten very confused as to the best way to achieve this. I could use some help - I am interested in some tutorials
How to give a unique ID number incrementing by one?
Hi, I have a form for my users and I want to have a hidden field where the form will automatically assign a unique ID number to each user that fills the form. The ID number shall start with 1 and increment by 1 in each form submit. How can I do it? Many thanks, Vera
if .... then .... image
hi is it possible that one field (image) is dependent on the second one? Image should be put automaticly (just like formula) depending to the value of the field Decimal e.g. DECIMAL | IMAGE 10 | image1 20 | image2
Limit access top view
I have a view/report that I would like either the Added_User to have access to it OR a special group of users (they can be developers) to have access to it. In the criteria I'm able to set the first condition (Added_User = zoho.loginuser), but how can I include the second "OR" condition? Any ideas? is there a way to do it without creating two different views and use the Share method. Thank you
Help with field please
Within my database I am using a drop-down field to sort the days of the month using the grouping feature. it works very well apart from one thing. In the drop-down choices I have (for Sept) 01 Sunday 02 Monday 03 Tuesday 04 Wednesday al the way down to 30 Monday Next Month (Oct) the 1st is a Tuesday So I have to edit the field and change the choices to 01 Tuesday 02 Wednesday 03 Thursday 04 Friday al the way down to 31 Thursday Is there a way to automate the field please Thanks
REstrict users to update certain fields only
I wanted to create a view so some users will only be able to see certain fields of a forum; plus they can only update certain fields but not all... how can I do this? Thanks.
change symbol
Hi, 3 Fields Name Job code Scan code Name John Brown Job code BRO1276/1/402 Scan code John Brown BRO1276/1/402 Code is input.scan_code = name = job_code All this is no problem apart from this I want Scan code to read John Brown BRO1276-1-402 I want - instead of / The reason I cant do this when entering the job code is that we cut and paste Can anyone tell me how to change the / to a - in a formula Thanks
Format Note Field in Script
Hi I would like to know how to format the note field via script. Thanks!
Add a folder on computer
When I enter a new record on my database I create a folder on my computer to store the results of the job. So I create the record go to the field for the folder name Copy the field entry go to my desktop create new folder name it the text I copied from the record My question is Can I get creator to create a folder on my desktop and name it as the content of a specified field Thanks
Exporting to spreadsheet - cannot get to the button
Hi I am having a problem on IE and Firefox when trying to export to a spreadsheet. When I click on the cog then export the list of options appears but they do not appear next to the export option. There is a slight gap so when trying to select the spreadsheet option it disappears. It's really frustrating. Does anyone have any ideas on why this may be happening? Thanks
Sharing limits
Is there any way to share an application, allowing all viewers to view and search, but not to print or export any of the information?
double column form
Althought there is an option to have a double column form, that doesn´t seem to be working. After clicking on this option, a second column appears on the screen, but I cannot move any of the fields to it. What am I doing wrong ? Thanks
change application link
Is it possible to change the application link, the part that comes after http//:creator.zoho.com/ ? Thanks.
Parameter Types in HTML View
Hello, I am creating an html view to get a nicely formatted, custom output view of my data. I have encountered an issue in trying to pass numeric or date fields to parameters in the html view. The template variable saleprice is of type STRING. But you are trying to update it with an expression of type BIGINT It seems that parameters default as string type. Is there a way in the script to set individual parameters as something other than string? Many thanks. Justin
Link to EXCEL - Problem with multiple line fields
I was able to link a view to Excel by using both Excel's Web Data Query and Zoho html permalink . This is very handy because I can build a lot of reports in Excel and then just refresh the data. The issue that I have is with one text field in Zoho, which has multiple line. This field gets broken down into multiple rows in Excel. Any suggestion on how to fix this? thanks
How do I change a number field to text field?
I've a field called student ID, which is mainly populated by numbers. One new ID contains a letter to cannot be entered. How do I change the field type? Thanks Mel
Annoying Code Comment issue
Hello, Let me start by saying the Creator application builder system and deluge code are absolutely amazing. I have been able to build an powerful application from scratch in less a month. My question is related to being able to write comments in my deluge code for readability. When I write a comment right after an "IF" state state the IF statement somehow absorbs the comment to within the "}". this is very annoying and makes commenting code with a lot of conditional statements hard. For example
Creating a HOME button in Views/Reports
Hi I've been trying to create a link to HOME in Reports/Views, after countless user requests. Have finally found a way of doing this that doesn't require IFRAMEs or embedding. I've just sent a message to support to see it its okay, because it seems to break some unexplained condition in one of Zoho's Help pages. For the record, here's how (and this could be used to create a full Nav menu and other things) Open the relevant View and then * Click on Edit this application * Click Create New * Click
How to create a custom sort key
I'd like to be able to sort data in a view by a custom key (i.e., not by a standard alphabetical, numerical, or date sort). I'm a pastor, and have an application that I have developed to keep track of my preaching schedule. It has the following forms (among others): Sermon Series (each entry is a separate sermon series) Field: ID (autonumber integer) Field: Series Name (string) Field: Description (rich text) Sermons (each entry is a distinct sermon) Field: Sermon Date (date) Field: Sermon Series
Formula based on a join
Two tables: Tutor - holds records of tutors Associate - holds records of associates (students) One tutor to many associates. I have a form on each one. I have a report on associates which is grouped on tutor so shows each tutor with their associates. I have a report on tutors. I'd like it to include the count of associates against the tutor. The Associate form has a field which is a lookup to the Tutor "name" field. I've tried adding a formula field to the tutor form, with an expression based on
Can Print option include the search criteria?
Before printing from a view it is common to search for specific values in the view. A nice feature would be to include the search criteria on the top of the printed output. Is there any work around to accomplish this currently? Herb Wexler
Next Page